Hi Greg,
If you're using 6.0, you can use the following:
COPY TO mytxt.txt DELIMITED WITH _ WITH CHARACTER ","
StrToFile(strtran(FileToStr('mytxt.txt'),'_', ''), 'mytxt.txt')
>Is there a way to use the copy to command to create a text file in which the character fields don't have quotes around them? I still want the fields separated by commas.
>Thanks
kenweber
GCom2 Solutions
Microsoft Certified Professional