View Single Post
  #16 (permalink)  
Old September 15, 2011, 06:21 AM
Keywork's Avatar
Keywork Keywork is offline
Join Date: Jun 2009
Location: Niagara
Posts: 602

My System Specs


Originally Posted by Squeetard View Post
I'd run a search and replace to change any existing comma's to semi-colons first. Even if they did not cause a bug in your conversion routine, they will mess up the csv file.
Yup, I need to add a line in there to replace all commas and quotation marks with semi-colons or something. I'll try to make the adjustment quickly after i'm out of class. It's only one or two lines...

Note: I forgot to mention that last night when testing it quickly, I added some random quotes to the input file and ran the script. When I opened it in LibreOffice, it the CSV was broken, but when opened in Office, it was fine...
Reply With Quote