• Login
Community
  • Login

Specific Column Value to Rows

Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
4 Posts 3 Posters 983 Views
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.
  • S
    Shaun Hill
    last edited by Oct 14, 2022, 5:38 PM

    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

    T P 2 Replies Last reply Oct 14, 2022, 5:50 PM Reply Quote 0
    • T
      Terry R @Shaun Hill
      last edited by Oct 14, 2022, 5:50 PM

      @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

      S 1 Reply Last reply Oct 14, 2022, 6:17 PM Reply Quote 0
      • P
        PeterJones @Shaun Hill
        last edited by PeterJones Oct 14, 2022, 5:53 PM Oct 14, 2022, 5:52 PM

        @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
        • S
          Shaun Hill @Terry R
          last edited by Oct 14, 2022, 6:17 PM

          @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
          1 out of 4
          • First post
            1/4
            Last post
          The Community of users of the Notepad++ text editor.
          Powered by NodeBB | Contributors