>>>Hello !
>>>
>>>My VFP 3.0 doc. states in the "Copy To" help that "The default field separator is a comma."
>>>I need to export a delimited .txt file with a " ; " as field separator. Can this be done from within FoxPro 3 ?
>>>
>>>//Christer Klingstedt
>>
>>I think so,
>>
>>COPY TO ..... DELIMITED WITH ";"
>>
>>Is supported in V5, I think it's in 3 also.
>
>
>Thanks - However the "delimited with .. " option changes the character that delimits character fields (usually double quotation marks), not the field separator...
>
>//Christer K.
Here's an extract from VFP5 Help :-
Note that the WITH Delimiter clause can be combined with the WITH CHARACTER clause. For example, the following command creates a text file with character fields delimited with underscores and all fields delimited with semicolons:
COPY TO mytxt.txt DELIMITED WITH _ WITH CHARACTER ‘;’
Somewhere here is your answer, as long as this works in VFP 3 :-)