July 13th, 2010 at 6:10:41 PM
permalink
Just wondering if there's a way to re-format this file without the comma's and in a single column?
I downloaded the file to Notepad and Wordpad.
I've tried the Edit - Replace - Find what: , - Replace with: , "n/l"
That failed...
I sent email to the Wizard last Thursday - I know he's very busy.
First post ever, hope this is the correct forum/thread.
Thanks Wizard/JB for your web sites!
I downloaded the file to Notepad and Wordpad.
I've tried the Edit - Replace - Find what: , - Replace with: , "n/l"
That failed...
I sent email to the Wizard last Thursday - I know he's very busy.
First post ever, hope this is the correct forum/thread.
Thanks Wizard/JB for your web sites!
There is a flip side to that coin.
July 13th, 2010 at 6:17:00 PM
permalink
4,2,24,35,8,31,31,11,2,5,11,00,34,22,23,2,9,32,27,26,27,7,23,17,6,14,22,27,28,27,28,19,11,4,14,23,19,19,3,14,24,34,31,
You can probably do it in Word. After the replacement save it as a .txt file.
You can probably do it in Word. After the replacement save it as a .txt file.
July 13th, 2010 at 6:34:16 PM
permalink
Will give it a try - thanks.
There is a flip side to that coin.
July 13th, 2010 at 7:55:45 PM
permalink
did not work w/Wordpad - thank God for Google, came across Editplus site - comma's replaced by newline!
There is a flip side to that coin.
July 14th, 2010 at 9:43:34 PM
permalink
For future reference, you should be able to do that in wordpad, notepad, or any basic text editor. do a find/replace. Fill out the dialog box like this:
find: ","
replace: "\n" (Unix/Mac OS X) or "\r\n" (Windows)
Then hit "replace all".
Alternatively, you could use something like a regular expression, but that's not necessary here.
find: ","
replace: "\n" (Unix/Mac OS X) or "\r\n" (Windows)
Then hit "replace all".
Alternatively, you could use something like a regular expression, but that's not necessary here.