trinity
trinity
  • Threads: 2
  • Posts: 15
Joined: Jul 8, 2010
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!
There is a flip side to that coin.
pacomartin
pacomartin
  • Threads: 649
  • Posts: 7895
Joined: Jan 14, 2010
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.
trinity
trinity
  • Threads: 2
  • Posts: 15
Joined: Jul 8, 2010
July 13th, 2010 at 6:34:16 PM permalink
Will give it a try - thanks.
There is a flip side to that coin.
trinity
trinity
  • Threads: 2
  • Posts: 15
Joined: Jul 8, 2010
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.
bluefire
bluefire
  • Threads: 10
  • Posts: 156
Joined: May 24, 2010
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.
trinity
trinity
  • Threads: 2
  • Posts: 15
Joined: Jul 8, 2010
July 15th, 2010 at 6:11:34 PM permalink
Thanks bluefire
There is a flip side to that coin.
  • Jump to: