>>>>I have a .txt file that has a few fields delimited by a ~
>>>>
>>>>What is the syntax to import that .txt file into a cursor (or a temp table) ??
>>>
>>>APPEND FROM should give you what you need (you can experiment with the WITH DELIMITER or WITH CHARACTER clauses).
>>
>>I tried this:
>>
>>APPEND FROM myfile.txt DELIMITED WITH '~'
>>
>>...but all I get is data in the 1st column (there are 14).
>>
>>same thing happens if I try this:
>>
>>APPEND FROM myfile.txt FIELDS column1, column2 delimited WITH '~'
>
>How about ... DELIMITED WITH CHARACTER ~ (note no quotes around the tilde)
Interesting. So this fails:
APPEND FROM myfile.txt FIELDS column1, column2 DELIMITED WITH '~'
and this works:
APPEND FROM myfile.txt FIELDS column1, column2 DELIMITED WITH CHARACTER
Not sure what the heck the difference is....but whaaatever - it works. Thanks!
ICQ 10556 (ya), 254117