Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only