Creating a fixed width text file

Database

Creating a fixed width text file

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?

Thanks!

2 REPLIES
Supporter

Re: Creating a fixed width text file

"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

Enthusiast

Re: Creating a fixed width text file

Sometimes you face this issue if the data contains unicode characters. Does your data contain any unicode characters?