Page 1 of 1

Turn a horizontal csv file into a non csv separated vertical

Posted: Tue Jul 31, 2012 8:24 am
by apicius
Hi

I'm new to the forum but have been a subscribed and occasionally free user for some years.
Now for the first time I have a problem.

I am try to convert a wrapped, comma separated,horizontal list of about 80,000 words into one single line vertical listing.

I could of course do it manually...but thought I'd give the forum a try first.

Thanks in advance.

Apicius.

Posted: Tue Jul 31, 2012 8:50 am
by ak47wong
Perform a Replace operation as follows:

Find what: ,
Replace with: \n

Select Regular expression.
Click Replace All.

Posted: Tue Jul 31, 2012 9:12 am
by apicius
Hi ak47wong

Firstly,thanks for rapid response, and many thanks for the information...I now have my list.

Thanks again.

Apicius