>I had a text file which has data that delimited by two different delimiter like | and ~. When I try to append it into a database, I could only delimited by one delimiter and append a whole section of field into one of the field in the database (I use memo field). The question is how can I delimited the memo field further so that it goes to the correct fields.

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.