>>But the CHRTRAN() only take an expression. The first time I delimited the fields from the text file, I store it into database field. The fields now contain ~blah~~blah~.. if I use CHRTRAN() I had to hard code all the expression. How can I make it dynamic!!
>>
>>>
>>>You better open text file with low-level functions, assign all file contetns to string variable, use CHRTRAN() to replace extra delimiter, save string into new txt file, and now you can run APPEND FROM safely.
>
>Hi,
>This could be wrong for I couldn't see the original question.
>You could use strtran instead of chrtran.
>cOutString = strtarn(strtran(cInString, "[[","["),"]]","]").
>Cetin

Have you tried taking the text file into Word and Replace all ~ with |? The new file should import fine.