I think I have not made myself understood.
I am performing a COPY TO to an ASCII file. I prefer to delimit the ASCII file with a tilde (~). I need to have a tilde between ALL fields with NO OTHER DELIMITER in the file so I can BCP the data into SQL Server 6.5.
If I do [COPY TO xx.txt DELI] then I get quotes and commas. If I do [COPY TO xx.txt DELI WITH "~"] then I get commas around the numeric data and ~ around the character data. If I do [COPY TO xx.txt DELI WITH "~"] then I get tildes around the numeric data and quotes around the character data.
>And the old SYS(15) function might be even better (though I´m not sure whether it´s still supported, and I cannot check for I don´t have VFP installed in the PC I´m working in just now).
>
>>CHRTRAN might work better than STRTRAN in this instance.
>>
>>>Bob,
>>>
>>>If you need to look for quotes through-out your information:
>>> STRTRAN(InfoToChk, ["], [])
>>>
>>>-myron kirby-
>>>========================
>>>>I need a FAST way to strip quote marks from [COPT TO] ASCII output. It will be stripping over 4,000,000 records with multiple quote marks.
>>>>
>>>>I am wondering if low-level program code is the best and fastest way to do it.
>>>>
>>>>Thanks,
>>>>
>>>>Bob
Database Development Team