>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