Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delimited with colon
Message
 
To
30/06/1997 11:23:37
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00038100
Message ID:
00038123
Views:
43
>>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
Map
View

Click here to load this message in the networking platform