Information générale
Catégorie:
Codage, syntaxe et commandes
>>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??
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement