Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export to a csv
Message
 
To
26/06/2003 11:39:38
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00804218
Message ID:
00804254
Views:
41
Ok, CSV option can give you a header, and delimeter option can give you delimeter that you need. Unfortunately you cannot combine them together in one /copy to.../ statement (at least at this moment I cannot remember howtodoit)

There is a number of solutions however. For instance,

copy to filename.csv delimet with character....
=afields(afld)
lcheader=""
for ia=1 to alen(afld,1)
lcheader= lcheader+iif(ia=1,'','|')+afld[ia,1]
endfor
=strtofile(lcheader+chr(13)+chr(10)+;
filetostr(filename.csv),filename.csv)



>now the , is not there but it put me " nad i dont want this
>
>"ex1"|"ex2"|
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform