Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem Characters in CSV File
Message
From
15/11/2003 07:45:44
 
 
To
15/11/2003 05:37:22
Stuart Ramsey
Medical Business Systems
East Gosford, Australia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00850208
Message ID:
00850218
Views:
22
Hi Stuart

> Have tried FiletoStr, StrTran then StrtoFile to replace chars with blanks, doesn't work.

You should be able to get these using CHRTRAN() or STRTRAN() - but you have to specify them as CHR(XX) as follows:

0A = CHR(10)
0B = CHR(11)
0C = CHR(12)

Thus:

lcResult = CHRTRAN( lcInString, CHR(10)+CHR(11)+CHR(12), '' )
----
Regards
Andy Kramek
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform