Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating csv file
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01613741
Message ID:
01613744
Views:
50
>I am trying to produce a delimited text file
>
>COPY TO d:\eudora\attachb\testa.csv DELIMITED WITH "~"
>
>But that puts the ~ before and after every field so my file looks like
>
>~Colin New York Inc~ ~14th Floor~ ~World Trade Center~ ~New York~ ~NY10001~ ~Colin Northway~ ~0016468424105~ ~~ ~colin@colin-northway.com~ ~COL999~ ~816227~ ~~
>
>
>What is the correct instruction?

sorry slight brainstorm now am using copy to d:\eudora\attachb\testa.csv Type Delimited With Character ~ BUT

"Colin New York Inc"~"14th Floor"~"World Trade Center"~ I don't want the quotes how do I get rid of them?
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform