I would use this:

copy ... to (filename)....

=strtofile(chrtran(filetostr(filename)," ","+"),filename)

>That was the one I didn't try, I was almost out of choices!
>PS, what if I wanted output to look like:
>811AD,SUDBURY++++++++,B021193
>note the '+' being spaces.
>
>
>
>>Try:
>>COPY .. to .. delim with ""
>>
>>>I have the below data in a table acct(5), location(15),label(5)and I want to create the txt file shown below. Do I use copy to output type sdf, delimited, delimited with ",", not having too much luck creating what I want.
>>>
>>>
>>>"output.txt" =
>>>811AD,SUDBURY ,B021193
>>>811AD,SUDBURY ,B020910
>>>811AD,SUDBURY ,B022401
>>>811AD,SUDBURY ,B023021
>>>811AD,SUDBURY ,B023207
>>>811AD,SUDBURY ,B024342
>>>811AD,SUDBURY ,B024341
>>>811AD,SUDBURY ,B024382
>>>811AD,SUDBURY ,B024351
>>>811AD,SUDBURY ,B024352
>>>811AD,SUDBURY ,B020809
>>>811AD,SUDBURY ,B021653
>>>811AD,SUDBURY ,B023958