CSV Issues with quotes after a number

[Chris Rendall]

I use the xlate command to remove the " from the data before export.  

--- Chris

-----Original Message-----
From: FilePro List [mailto:mikefedkiwfp at aol.com] 
Sent: Tuesday, April 15, 2014 2:28 PM
To: filepro-list at lists.celestial.com
Subject: CSV Issues with quotes after a number

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
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/mailman/listinfo/filepro-list