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."
