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