In the Specification clause, can I combine functions
i.e. String_trim[" ",end](substring[3,6]field_A)
If not, is there another way
Modify Stage
Moderators: chulett, rschirm, roy
Re: Modify Stage
Yes you can. Here is an example:
INTRN_STAT_CDE = handle_null(string_trim(INTRN_STAT_CDE)," ")
INTRN_STAT_CDE = handle_null(string_trim(INTRN_STAT_CDE)," ")
Assume everything I say or do is positive