Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I append from delimited file
Message
From
16/10/2003 20:30:03
 
 
To
16/10/2003 19:34:29
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00839564
Message ID:
00839582
Views:
18
>>Are the weird characters always the same? And what are they? And would they ever be in the actual data?
>>
>>You could fix the file as a whole - let's say the characters are all Chr(255) and chr(255) wouldn't ever be real data
>>
>>
StrToFile(StrTran(FileToStr("weird_file.txt"), Chr(255)),"weird_file_clean.txt")
>VFP does not recognize these characters. When the export file is open in VFP with MODI COMM, they appear as little squares.

Thanks, it works with CHR(0)

Edward
Previous
Reply
Map
View

Click here to load this message in the networking platform