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

Click here to load this message in the networking platform