I'm pretty sure your suggestion only works with VFP.

>Try the following syntax
>
>append from delimited with character '|'
>
>-myron kirby-
>myronk@flash.net
>------------------------------------------
>>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