Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Removing CR * LF from CSV file
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01440894
Message ID:
01440910
Views:
52
>>>Try using filetostr/strtofile functions and then CHRTRAN or STRTRAN functions.
>>>
>>>lcFileStr = filetostr('myFile.txt')
>>>lcFileStr = chrtran(m.lcFileStr, chr(13) + chr(10),'') && to remove all of them at once - the file will be one long line now
>>>
>>>strtofile(m.lcFileStr,'myFile1.txt')
>>>
>>>append from myFile1.txt
>>
>>Because they foul up the append
>>
>>Thanks
>
>I'm not sure how, but using the code like above for small files or low-level file operations for bigger files may help you out.

See my reply to Sergey but I think your answer will solve problem

Thanks
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform