DSXchange

Is there a way to combine the following command in the specification line of the modify stage.

CD = string_trim[" ",end](substring[3,6](CD))

I get an error.

The CD column is a VarChar type. I need to trim the spaces for the lookup stage. Even though I use substring, I must suppress the remaining spaces.

Thanks

I've tried combining commands in a modify stage as well and have come to the conclusion that this is not possible.

Yeah I have had the same results. I would like to see IBM expand this stage to be more useful.