General information
Category:
Coding, syntax & commands
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only