All Forums Database
lmgingrich 1 post Joined 07/12
24 Jul 2012
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!

ulrich 816 posts Joined 09/09
24 Jul 2012

"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

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

Qaisar Kiani 337 posts Joined 11/05
24 Jul 2012

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

You must sign in to leave a comment.