Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating ASCII Text Files
Message
From
09/12/2002 10:28:44
Rebecca Stottlemire
Kansas State Department of Commerce
Topeka, Kansas, United States
 
 
To
09/12/2002 09:39:34
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00730853
Message ID:
00730894
Views:
8
Unfortunately, I'm still in 6.0. Someone pointed me to FAQ #8016, I'm going to try to work with it.
Thanks,
Becky

>Are you using VFP7?
>
>If so, have you tried:
>
>
>COPY TO newfile.txt DELIMITED WITH "" WITH CHARACTER ','
>
>
>
>>I have a dbf of about 80,000 500-byte records that needs to be written out to an ASCII text file for upload to another system. They want it comma delimited WITHOUT the quotes on text fields. When I do the COPY TO DELIMITED, I get the quotes around the fields.
>>
>>I have tried the strtofile function below which works on smaller files but on one this large, I get an out of memory error.
>>
>>Is there some way to parse the file and do it a little at a time? Or is there a better way to get an ASCII file.
>>
>>Thanks for any help you can give me.....here's what I tried:
>>
>>llReturn=strtofile(strtran(filetostr(lctempfilename),["],''),lcnewFileName)
>>
>>Becky
Previous
Reply
Map
View

Click here to load this message in the networking platform