Sytze,
Use StrTran - Example:
Strtran("Hello There","o T","") => "Hellhere"
So, in your program you do the following:
cCrLf=chr(13)+chr(10)
So cNewString=strtran(cOld_String,cCrLF,"")
Dave Crozier
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Sytze de Boer
Sent: 27 November 2008 08:24
To: [email protected]
Subject: Re: VFP9 - CSV files
Hi Folk
Once again, I am indebted to Profox and all you folk who try to help me
Hopefully, on elast question.
How do you detect the presence of a carriage return and line feed, and
how do you strip out.
I think a carrigae return and line feed is the ctrl(13) and ctrl(10)
factors.
But, how do you detect, and how do you strtran them out ?
Sytze
On Thu, Nov 27, 2008 at 11:19 AM, Paul Hill <[EMAIL PROTECTED]>
wrote:
> 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
>
>
[excessive quoting removed by server]
_______________________________________________
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.
