Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating ASCII Text Files
Message
From
09/12/2002 12:32:03
Rebecca Stottlemire
Kansas State Department of Commerce
Topeka, Kansas, United States
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00730853
Message ID:
00730999
Views:
6
Yippee! it worked. I used Q277725 as a model. You guys are so good!
Thanks,
Becky

>You can also use LLFF. Here's a sample code.
lnIn = FOPEN(lctempfilename)
>lnOut = FCREATE(lcnewFileName,2)
>DO WHILE NOT FEOF(lnIn )
>  FPUT(lnOut, CHRTRAN(FGET(lnIn,1024), ["], []))
>ENDDO
>FCLOSE(lnIn)
>FCLOSE(lnOut)
>
You'l have to add some error handling to it.
>>Thanks. This gives me a place to start...unfortunately I'm still in 6.0, but will keep trying.
>>Becky
>>
>>>See Re: Copy to COMMA DELIMTED but no quotes around char Message #609218.
>>>
>>>>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