CSV Issues with quotes after a number
FilePro List
mikefedkiwfp at aol.com
Tue Apr 15 12:27:58 PDT 2014
I am trying to export some information from my inventory file to a CSV
file. The info I need to export is item numbers, descriptions, prices,
etc. I'm having issues with the description field because some records
contain a quote after something like a length like 24". In those
instances, it sucks the next field into the description field cell with
a comma placed between them. This only happens if its a number followed
by a quote, letters with quotes after them work out just fine. I even
tried changing the edit type on the description fields to see if that
made a difference but it didn't. I also was just thinking that I could
move the description field to the fart right and there wouldn't be
anything to suck over but after doing that, it actually sucked up the
next line under it.
Any help would be greatly appreciated
Thank You, Mike
Filepro 5.0.09DN9
MS Excel 2003
Server 2003
More information about the Filepro-list
mailing list