CSV Issues with quotes after a number

[ernieb59]

Can you use a pipe (or other) delimiter instead?
Ernie


-----Original Message-----
From: filepro-list-bounces+ernieb59=gmail.com at lists.celestial.com
[mailto:filepro-list-bounces+ernieb59=gmail.com at lists.celestial.com] On
Behalf Of FilePro List
Sent: Tuesday, April 15, 2014 3: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
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4355 / Virus Database: 3882/7347 - Release Date: 04/15/14