I have a fixed width file with the leading spaces for all the columns. I would like to trim all the data so all the columns come in left justified. Is it possible to use the trim command inside the control file?
What would be an alternative method?
Printable View
I have a fixed width file with the leading spaces for all the columns. I would like to trim all the data so all the columns come in left justified. Is it possible to use the trim command inside the control file?
What would be an alternative method?
In your control file, when defining the fields you can also put a peice of SQL on the field and you do it something like this
field POSITION(1:9) CHAR(8) "rtrim(:field)"