I replace nested double quotes with single quotes, commas with semi-colons, and 
backslashes with forward slashes before outputting to csv.

Gil  
Sent via BlackBerry by AT&T

-----Original Message-----
From: "Paul Hill" <[EMAIL PROTECTED]>

Date: Wed, 26 Nov 2008 22:19:04 
To: <[EMAIL PROTECTED]>
Subject: Re: VFP9 - CSV files


On Wed, Nov 26, 2008 at 9:47 PM, Jeff Johnson <[EMAIL PROTECTED]> wrote:
>   =FPUTS(lnhandle, lcstring)

One thing you might want to check is double quotes in the data.
I believe in CSV files these are double quoted.  You can use STRTRAN
to replace " with "".

Also, seeing as this is a memo field you may or may not want to strip
out carriage returns and linefeeds...

-- 
Paul


_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Report [OT] Abuse: http://leafe.com/reportAbuse/[EMAIL PROTECTED]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to