>>Hi everyone,
>>
>>VFP6.0 SP5
>>
>>I have a requirement to create a text file from our database, where delimiters would be |^ (two symbols) and char data would not have quotes. Files have ~250 fields and may be huge.
>>
>>I'm thinking about two possible approaches:
>>1) Scan the file and process it manually (here is a subquestion: do it through textmerge or create chunk string and put this string into file)
>>
>>2) Use copy to command and process the file afterward (Need some fll to make this replacement).
>>
>>What do you think would be better? Does somebody have a similar experience and some benchmarking?
>>
>>Thanks a lot in advance.
>
>Nadya,
>Would you elaborate this more. I think you don't mean :
>
>COPY TO myfile.txt TYPE DELIMITED with '|' WITH CHARACTER "^"
>
>Cetin
No, it inserts additional chars instead. We need Field1|^Field2|^Field3|^Field4
If it's not broken, fix it until it is.
My Blog