CSV Issues with quotes after a number

[Nancy Palmquist]

I ran into this many years back.  My customer was using " for inches in 
a description.

We had them change to using '' which is two apostrophies, instead of a 
single quote.  It appears similar and does not mess up filePro.

Commas or linefeeds are also an issue when filepro reads a csv file.  
Filepro will write a file with linefeed/carriage returns in fields but 
will not read them.

Nancy
On 4/15/2014 3:27 PM, FilePro List wrote:
> 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
>

-- 
Nancy Palmquist
Owner
Virtual Software Systems - www.vss3.com
(412) 835-9417