CSV Issues with quotes after a number

[Bill Campbell]

Can you use tab-delimited files instead of CSV?

Will the CSV files work if one escapes the " with '\'?

On Fri, Apr 18, 2014, Nancy Palmquist wrote:
>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
>
>_______________________________________________
>Filepro-list mailing list
>Filepro-list at lists.celestial.com
>Subscribe/Unsubscribe/Subscription Changes
>http://mailman.celestial.com/mailman/listinfo/filepro-list
>

-- 
Bill
-- 
INTERNET:   bill at celestial.com  Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
Voice:          (206) 236-1676  Mercer Island, WA 98040-0820
Fax:            (206) 232-9186  Skype: jwccsllc (206) 855-5792

Just because you do not take an interest in politics doesn't mean politics
won't take an interest in you. -- Pericles