Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delimited with colon
Message
 
À
30/06/1997 11:23:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00038100
Message ID:
00038123
Vues:
41
>>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
Fil
Voir

Click here to load this message in the networking platform