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
Modify Stage - Combining Commands
Moderators: chulett, rschirm, roy