I need help with Notepad's Find & Replace tool. I have a txt file containing over 1000 names seperated by "," (comma) would like to remove the comma and move each name to the next row. Can someone help me with the instruction to input into the REPLACE tab? Exisiting format: xxxxxxxx xxxxxx, yyyyyy yyyyyy, aaaaaa aaaaaa, wwwwww, xxxxxx, eeeee, aaaaa, ddddd What I want: xxxxxxxx xxxxxx yyyyyy yyyyyy aaaaaa aaaaaa wwwwww eeeee aaaaa ddddd
paste it into excel them remove cells.. very simple.. send me the file (if it is not confidential) and I will do it for you for free.
Unfortunately its a confidential file if not i would have used your help. I tried via Excel its not possible because all the data is copied to the same cell.
There are always ways to do that... try saving your note pad into html file.. then open the file as webpage.. select all and copy the content, post it again into note pad, then copy and post it into xcel... This sounds odd but doing trial and error, I'm sure you can solve it.. I have same problem before but after doing several conversion, I solved it.. good luck..
Bingo! Thanks for the lead I got it solved. this is what I followed Save the file as .html Open the file with a html editor Press "Ctrl+f" to find. Click on the "replace" tab In "find what" put in "," (comma without quotes) In "replace with" put in "<br/>" (again, without the quotes)
I'm happy for you man.. I saw you post the same in WF but I'm not sure if they able to help you... you cannot learn this in school.. congrats