suppress trailing zero

[karthi_gana]

All,

I have a sequential file the below data.

100|2.156789345000000
100|2.620000000000000
100|2.234234132423240
100|2.100001000000000

I would like to remove the trailing zero's from the file. is it possible?

Expected Output:

100|2.156789345
100|2.62
100|2.23423413242324
100|2.100001

Inputs are welcome!

[chulett]

So, your target is another file?

[srinivas.g]

you can use below derivation in transformer stage
trimb(columnname,'0')

[gateleys]

Try:

Code: Select all

TRIM(YourValue,"0","T")

Here, "T" implies Trailing.

[ray.wurlod]

Yes it's possible, but only if the target data type is a string of some kind.

[karthi_gana]

Thanks for all . It works fine.