Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating ASCII Text Files
Message
From
09/12/2002 09:35:40
Rebecca Stottlemire
Kansas State Department of Commerce
Topeka, Kansas, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Creating ASCII Text Files
Miscellaneous
Thread ID:
00730853
Message ID:
00730853
Views:
35
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
Next
Reply
Map
View

Click here to load this message in the networking platform