CSV Issues with quotes after a number

[Walter D Vaughan Jr]

Then you have at least two more options. 
1) Export from filePro as a fixed format file and import as same in to Excel
2) Install SQL Server Express and setup a SSIS package to read your filePro
data as flat files and allow Excel to access the data somewhat natively (ala
ODBC or ADO) and of course this is a lot of work
3) Write your export to put the data into XML format which was developed in
part to eliminate this type of problem
4) translate your quote marks into the work inches before exporting

> -----Original Message-----
> From: filepro-list-bounces+wvaughan=steelerubber.com at lists.celestial.com
> [mailto:filepro-list-
> bounces+wvaughan=steelerubber.com at lists.celestial.com] On Behalf Of
> FilePro List
> Sent: Tuesday, April 15, 2014 5:07 PM
> To: 0 Filepro List
> Subject: Re: CSV Issues with quotes after a number
> 
> 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
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list