mike can you recheck your select statement, vfp didn't like it.
>Select acct, padr(alltrim(location),"+",15) as location, label into newcursor
>COPY TO ...
>
>>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
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."