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

Microsoft VFP MCP
Menulib - OO Menus for VFP www.hidb.com/menulib
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform