>I had to import a text file which has pipes as the delimiter. When I use APPEND FROM DELIMITED WITH | I get a bunch of records with blank fields. I went into Modi file and replaced all the pipes with commas. Then I reissued the append command as "Append from type delimited", and the data came over into the table with no problem. Does anyone have any idea why this might have happened? > >Sylvia
Agree with other replies. If you need something that is very rarely used, try the tilde (~). I do and it works great.