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