View Single Post
rcull's Avatar
Posts: 299 | Thanked: 168 times | Joined on Jun 2006 @ Wales UK
#50
Back from my trip.

Green_Star

I've had a look at the file your having trouble with - There are newline characters within the data and crlf at the end of the line - it looks like a combination of a unix file and a dos file. If you have access to a linux ( or any unix for that matter ) the following from the command line should fix it.

Code:
cat Starbucks.csv | tr -d "\n" |tr "\r" "\r\n" > new.csv
Unfortunately I don't know of a way to do this from Windows.

Rick