Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating csv file
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01613741
Message ID:
01613744
Vues:
49
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform