>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