>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