Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to replace null character in text file??
Message
 
 
To
31/07/2001 13:26:54
Brent Smith
Guardian Life Insurance Company
Spokane, Washington, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00537868
Message ID:
00537891
Views:
12
This message has been marked as the solution to the initial question of the thread.
Try
lcStr = Filetostr("Myfile.txt")
lcNewStr = STRTRAN(lcStr, CHR(0), "")
=StrTofile(lcNewStr, "Mynewfile.txt"
>I have received a data file, exported from a Lotus Notes Table in tabular format. One field contains multiple values separated by what appears to be a null character. That is, it appears as a square box in common fonts and evaluates to zero in a ASC(SUBSTR(string,position,1)) function.
>I would like to find/replace, STRTRAN, STUFF, or other method to remove the offending character, but all methods known to me fail with this character.
>
>Help please.
>
>Brent
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform