>>>>I am attempting to append to a DBF from an ASCII file in which the fields are delimited by the vertical bar (|).
>>>>
>>>>The command
>>>>
>>>>Append from Tabular.dat delim with |
>>>>
>>>>does not work; I get the first ten characters of the line in the first 10-character field, and that is it.
>>>>
>>>>I have sucessfully appended about a million times before, but those were always comma delimited or SDF files.
>>>
>>>Hi Tina,
>>>use:
>>>Append from Tabular.dat delim with character |
>>
>>That returned "command contains unrecognized phrase/keyword".
>
>Try using "|" on the end.
And if Brad's solution as above does not work then you can also try using the Fox function - CHR(X) approach to define the delimiter where X is the appropriate decimal code number for the ascii character "|" symbol but I suspect that the simple "|" will work. Good luck Tina, sure would like your feedback as I often have to import data such as this but have not recently come across the "|" delimiter and am not sure what approach I used the last time that I did but I do know it is possible to do it because I have done it!!!