General information
Category:
Coding, syntax & commands
>>>>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 :-)
Seems that I have to upgrade (finally...) !
Regards
//Christer K.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only