Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing Comma Delimited Data
Message
 
To
20/11/2000 09:46:33
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00443605
Message ID:
00443613
Views:
7
>I am trying to import a txt file that is comma delimited using the APPEND FROM...TYPE DELIMITED command. Everything works great until I come across a carriage return in the txt file (this portion was originally a memo field in the program I created the txt file from). At this point the program interprets the carriage return as the begining of a field. From this point on everything is screwed up.
>
>Any suggestions, short of using a text editor to delete the carriage returns?
>
>Thanks in advance for your help.
>
>Russell

You could always use the FILETOSTR command then STRTRAN the carriage return to something else. Put the file back with STRTOFILE then try appending it in to a dbf. Once in the dbf you then can STRTRAN the field with the carriage return back to a carriage return from what ever you translated it to before.

HTH
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform