Hi Dore,

I'd say that would depend on the data. Of course you would want to use a character that would least likely to occur in valid data.

>Wouldn't it make more sense to use a pipe character (|) rather than underscore (_) since there is a greater likelihood of underscore being in the data to be copied. When doing the strtran() conversion all underscores will be removed.
>
>>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