Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating a CSV file with COPY TO
Message
De
24/04/2001 11:30:34
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00498815
Message ID:
00499069
Vues:
19
>>>I am driving myself nuts. Can this be done ? A simple CSV. No delimiter just commas to separate the fields. I am trying the DELMITED WITH BLANK ... and it still gives me a " for a delimiter !! HELP !!
>>>
>>>Thanks, Ken
>>
>>Kenneth,
>>Either copy to... type delimited or type CSV produce output using quotes as text delimiters. You could use delimited with ' ' but that adds extra space around text.
>>You could do this :
>>
copy to myFile.txt type delimited
>>StrToFile(chrtran(FileToStr('myFile.txt'),'"',''),'myOutPut.txt')
Cetin
>
>Also take a look in the recent FAQ "Removing double quotes from the file" which is based on Cetin's fll :)

ROFL. That's for huge files that can't be handled this way, isn't it.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform