Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Specific Column Value to Rows

    Help wanted · · · – – – · · ·
    3
    4
    115
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Shaun Hill
      Shaun Hill last edited by

      Hello All,

      I’m looking for advice with a specific issue I’m having.

      I would like to take a specific number of column data and make it a string in a row. I do know I can use regex [\r\n]+ in “Find What” and “Replace with” a “,” (which is what I want) but it takes the whole column data.

      For a work project I’m limited to a number of characters I can use. The total column data is roughly 60k, is there a way to only take 500 of the column data and do the same thing?

      I’ve tried Excel using =textjoin formula, but there is too much column data and gives me an error. Didn’t know if Notepad ++ had an easier way than manually selecting rows in Excel.

      Thanks all

      Shaun

      Terry R PeterJones 2 Replies Last reply Reply Quote 0
      • Terry R
        Terry R @Shaun Hill last edited by

        @Shaun-Hill said in Specific Column Value to Rows:

        I would like to take a specific number of column data and make it a string in a row.

        This seems to suggest you want a limited number of characters from each line, so truncating each line. Later it seems more like you only want the first 500 lines of data. Which is it?

        The first can certainly be achieved in Notepad++. The second, whilst also possible in Notepad+++ might be more achievable outside using one of the many command line tools to quickly edit text data, by splitting files.

        Terry

        Shaun Hill 1 Reply Last reply Reply Quote 0
        • PeterJones
          PeterJones @Shaun Hill last edited by PeterJones

          @Shaun-Hill ,

          When replying to @Terry-R’s request for additional information, please keep in mind the following useful references:

          • Template for Search/Replace Questions
          • FAQ: Where to find regular expressions (regex) documentation
          • Notepad++ Online User Manual: Searching/Regex
          1 Reply Last reply Reply Quote 0
          • Shaun Hill
            Shaun Hill @Terry R last edited by

            @Terry-R

            Thank you for your response Terry. I’ll dig into @PeterJones comments as well as your advice. Appreciate the quick responses and will follow up as soon as I can.

            Shaun

            1 Reply Last reply Reply Quote 0
            • First post
              Last post
            Copyright © 2014 NodeBB Forums | Contributors