I have been trying unsuccessfully to extract data to a fixed width text file for one of our business purposes. I created a table with the exact column settings that I want ... and I can use the export feature to export my results to a text file with results that 'almost' work. Unfortunately at the begining of the row of data I get 3 additional spaces or characters and I don't know why ... the characters look like this @ - with either a leading space or not. Not every line has the same combination of characters and some don't have any at all ... what is driving the addition of these characters and more importantly --- how do I get rid of them?
"and I can use the export feature"
which tool? please share the code?
google export fixed width text file teradata
and you will find many postings