Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Manipulations on the huge text file
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00364631
Message ID:
00364651
Views:
25
Hi Bret,

The problem is that command

COPY TO FILE myTextFile delimited with character tab

puts double quotes around character fields. Unfortunately, the output file must be without quotes. So, your suggestion would not work.

I found Mark McCasaland file 1082 and tried it, but the process was quite slow, so I terminated it. (BTW, question to Mark - is there a way to hit ESC and terminate a process without VFP 'Interrupt' message?).

Is it possible with WSH object?

Thanks in advance.



>>Hi everyone,
>>
>>I have a huge text file (~100 000 records with ~50-60 fields), Tab delimited. I need to remove all double quotations from this file.
>>
>>This is the algorithm, we used. It doesn't work on big files - we have an error: "String is too big to fit".
>>
>>What else could you suggest besides low-level functions?
>
>If the text file is delimited, couldn't you just append it into a cursor as delimited. Not just one huge memo field, but 50-60 fields and 100,000 records. Then SCAN ENDSCAN STRTRANing all the fields. This way the STRTRAN should be on a smaller size.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform