Modify Stage

[Raftsman]

In the Specification clause, can I combine functions

i.e. String_trim[" ",end](substring[3,6]field_A)

If not, is there another way

[csrazdan]

Yes you can. Here is an example:

INTRN_STAT_CDE = handle_null(string_trim(INTRN_STAT_CDE)," ")