replacing commas with new lines

oneilldo · 18 Feb 2006 at 15:52

Help my mind has gone blank. I am trying to sort out some data so I can import it easilt into a spreadsheet and then a DB and can't remember how to do the following easily. Change the file in format.
hello, test, hello2, test2
into the following format
hello
test
hello2
test2
i.e. all i want to do is search and replace ', ' with a new line character.
Any help will be good to help my mental block.

Thanks

Augmented · 18 Feb 2006 at 16:30

You'll need to replace ", " with "\n". How you do that depends on your search-and-replace tool of choice.

oneilldo · 18 Feb 2006 at 17:11

I tried that in notepad and textpad. The problem is it doesnt appear to treat it as a special character so I just end up with \n in the text

oneilldo · 18 Feb 2006 at 17:14

never mind I did it in word as I could replace the ', ' with a manual line break.
mental block is over