Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TAB character delimited
Message
From
20/11/2000 10:17:12
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
 
To
20/11/2000 07:21:57
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00443577
Message ID:
00443625
Views:
10
Ron,

You can't do it with COPY TO alone, but you can strip out the quotes afterwards by doing:
COPY ALL TO xx DELIMITED WITH TAB
STRTOFILE(CHRTRAN(FILETOSTR([xx.txt]), ["], []), [xx.txt])
>Hello every one,
>
>Could somebody please help me with the folowing:
>
>I have a FoxPro table and i have to create a TAB delimited file from it.
>When I try this statement: COPY ALL TO xx DELIMITED WITH '' WITH CHARACTER TAB
>It creates file xx but the fields are not fully correct. It looks like this:
>
>"Name" "Address" etc...
>
>I don't want to have the double quotes around the words. Could somebody give me the correct statement?
>
>I like to see the output like this:
>
>Name followed by CHR(9) a none visual character Address , etc...
>
>Thanks in advance
>Ron :)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform