Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy To - separators..
Message
From
07/12/1998 10:48:47
Christer Klingstedt
Karolinska University Hospital
Stockholm, Sweden
 
 
To
07/12/1998 09:48:41
Mark Hall
Independent Developer & Voip Specialist
Keston, Kent, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00164704
Message ID:
00164776
Views:
26
>>>>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
Map
View

Click here to load this message in the networking platform