>>>>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!