Trying to import a colon delimited text file to dbf via append from command. Problem is that in one of the fields (character type) the user is allowed to key in the Enter key hence resulting in the following text data on that particular record to drop down to another line. Even though the complete text is wrapped in the colon, the imported data is completely off from this field onwards.
Could not use strtran to remove this character as each line contain an end of line character as well.
Am open to any suggestions on this.
Thanks in advance.
Yau