Specific Column Value to Rows

Shaun Hill

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

@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

PeterJones

@Shaun-Hill ,

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

Shaun Hill

@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