>>>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)
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up