N
Nahum
Guest
I used TransferText to Export a record with Memo field in which there are line break characters.
When I import the text file back to the database, the line-break character in the memo field makes the string preceeded with the line-break character into a new record. That is, instead of 1 record, the import wizard thinks there are 2 records. For the example record followed, the first record starts at the beginning until "standard.html". The 2nd record starts at "To determine..."
I have tried Import Specification, fixed length, comma delimiter, but I got the error "Property not found."
Is the length of the memo the culprit?
Would you please show how to deal with the line-break characters in the memo field? We need the line-break for readability.
The following is one record with 5 fields with comma as delimiter. The data-type of the first field is long integer, the 2nd field is text of 20 characters, the 3rd field is integer, the 4th field is text of 80 characters, and the last field is memo of 512 characters.
18,"02.10-15-5",1,"Pre-Inspection Checks","Please see applicable Environmental Standards. Http://www.dkkad.com/t/kbus/AB/stations/PP/standards.html
To determine the condition of the transportation means and hence the work and spare parts required for the inspection and parts required for any corrective work that maybe necessary."
When I import the text file back to the database, the line-break character in the memo field makes the string preceeded with the line-break character into a new record. That is, instead of 1 record, the import wizard thinks there are 2 records. For the example record followed, the first record starts at the beginning until "standard.html". The 2nd record starts at "To determine..."
I have tried Import Specification, fixed length, comma delimiter, but I got the error "Property not found."
Is the length of the memo the culprit?
Would you please show how to deal with the line-break characters in the memo field? We need the line-break for readability.
The following is one record with 5 fields with comma as delimiter. The data-type of the first field is long integer, the 2nd field is text of 20 characters, the 3rd field is integer, the 4th field is text of 80 characters, and the last field is memo of 512 characters.
18,"02.10-15-5",1,"Pre-Inspection Checks","Please see applicable Environmental Standards. Http://www.dkkad.com/t/kbus/AB/stations/PP/standards.html
To determine the condition of the transportation means and hence the work and spare parts required for the inspection and parts required for any corrective work that maybe necessary."
