General information
Category:
Coding, syntax & commands
>>I am trying to append a text file where fields are seperated by colon, So I try the command
>>
>>Append From textfiles type delimited with :
>>
>>However, it doesn't seem to evaluate the colon instead it take as a string and appended whole record as one field.
>>
>>Thanx in advance!!
>
>There is some confusing between delimiter and separator:
>This line is field-delimited by colons
>:test:67:
>and "Append From textfiles type delimited with :" will work Ok.
>This line is just field-separated by colons
>test:67
>and "Append From textfiles type delimited with :" will yield worng results (exactly like you got).
>So either add two more : at the end/beginning of each line (you can write small function using low-level file functions to do this job) and use APPEND FROM, or use low-level functions only to import text file.
Thanks for your advise.
One other question, is it true that the a hard "return" or "linefeed" count as one record. If so, how can I append a text file which contains one record and each field is seperated by a hard return (one record per text file but seperated by a hard return for each field.) Or there's no solution to delimited by a hard return??
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only