Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COPY TO command
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
01134240
Message ID:
01134255
Views:
15
This message has been marked as the solution to the initial question of the thread.
>I'm doing a "COPY TO 'filename' TYPE CSV" from a vfp cursor.
>
>Everything is good except I need the first line in the csv file (which are the fields) to be upper case. One solution I thought about is opening the file and go character by character and changing to uppercase. Any other way to accomplish this?
>
>Thanks.
COPY TO ......
lcFile = FILETOSTR([NewlyCratedCSVFile.CSV])
lnAt   = AT(CHR(13), lcFile)
STRTOFILE(UPPER(LEFT(lcFile, lnAt-1))+SUBSTR(lcFile,lnAt),[NewlyCratedCSVFile.CSV], 0)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform