CSV Issues with quotes after a number

[FilePro List]

getting rid of the quotes in all of my descriptions is not an option. 
That would mess everything up.

On 4/15/2014 3:38 PM, Chris Rendall wrote:
> 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
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list