Forum Home
Press F1
 
Thread ID: 91763 2008-07-18 01:48:00 Replace a "comma space" with a new line in notepad++ Morgenmuffel (187) Press F1
Post ID Timestamp Content User
689941 2008-07-18 01:48:00 Ok

I have a number of lists I am editing (to include in a spreadsheet) and they are in this form

mlo46, hgdt75, hdsf6, fshdf765, 1245,...

and i want to convert them into this form

mlo46
hgdt75
hdsf6
fshdf765
1245
...


Now back on my old windows 2k machine I used to be able to do this using a search and replace in a text editor, however since it died i haven't had occasion to do this

I now need to and I cannot for the life of me remember how to do it

My current text editor is notepad++ I also have pspad installed (although I have virtually never used it)

any help would be greatly appreciated
Morgenmuffel (187)
689942 2008-07-18 01:54:00 if you have got ms word you can use ^l in the replace with field. smokey (13809)
689943 2008-07-18 02:17:00 yeah copy it all into ms word and use the replace tool to search for ", " and replace it with "^|" justinsg (11165)
689944 2008-07-18 03:03:00 In Notepad++, using the "Replace" command, tick "Regular Expression", and use '\n' without the apostrophes for the Replace With. somebody (208)
689945 2008-07-18 03:17:00 Thanks all

Somebody - that works fine, I was trying the "Ctrl r" then "Ctrl M" but couldn't figure how to automate, your way is much simpler and dare I say embarrassingly obvious, i feel really daft not figuring that out.
Morgenmuffel (187)
1