how to convert carriage return to comma separated for keyword list?

donjuan

Power Member

Oct 12, 2007

548

241

• Dec 24, 2009

• #1

hey guys need some help I would like to convert a keyword list from individual line items to comma separated or | (pipe) separated without having to use excel since I have no clue how to really use it with macros and all that jazz.
usually i do this by hand but this list is way too long.thx

 

Hellfire

Regular Member

Jun 27, 2009

241

151

• Dec 24, 2009

• #2

Open word -> ctrl+f -> replace -> replace "|" with "," -> replace all

 

K

kalatopi

Registered Member

Aug 3, 2008

50

30

• Dec 25, 2009

• #3

Open Word -> Ctrl+h -> replace "^p" (CRLF) with ", " (comma space) -> replace all.

Remove commas at the end if any.

 

donjuan

Power Member

Oct 12, 2007

548

241

• Dec 25, 2009
• Thread Starter Thread Starter

• #4

Yea I figured it out using notepad++ using reg expressions.

 

K

kalatopi

Registered Member

Aug 3, 2008

50

30

• Dec 26, 2009

• #5

Yes, Textpad is another tool like Notepad++ that speeds this up.