trim function not working

[sanoojk]

Hi,

My job is fetching data from netezza database , doing transformations in transformer stage and writing to netezza daatbase.

In the transformer I am using the transformation len(trim(column1)) where column1 is having datatype char2 . I can see all the input value for column1 is '5' , but the transformer output shows 2 where as the expected value is 1 .

I tried with the transformation len(trimb(trimf(column1))) but the same result.

Please advise any way to trim the column1

[priyadarshikunal]

change the datatype to varchar or do this calculation in varchar stage varibale and see if it works.

[chulett]

Your char field will always have a length of 2, that's the way CHAR works. It won't have "5" in it, it will have "5 " in it and even if you trim them, any trailing spaces will be automagically added back in. Again, all part of the nature of a CHAR field.

[rahcomp]

Simply assign the value to a stage variable with type VARCHAR(2) and use it in the output column of type VARCHAR(2) with trim function

[priyadarshikunal]

Simply assign the value to a stage variable with type VARCHAR(1) or CHAR(1) and use it in the output column of type VARCHAR(N) or CHAR(1)

Why in this world someone will truncate the string to from 2 characters to 1 character just because he is not able to trim it?

what if you get a two character string in input?