Transform If-then-else

[MsSamson]

In an Ascential Transform stage, I have a 4 byte control field "STRM" If the 4th byte is and "8", I need to set output field BALANCE to incoming field A. If the 4th byte is "2", the output field has to be set to incoming field B.

IF substring(STRM,4,1) = "8" THEN BALANCE = OFFER_BALANCE ELSE BALANCE = ZERO
(Balance is a field in the output, strm and offer_balance are fields in the input stream)
Can anyone offer a suggestion on how to do this?

 

[roatanbuzz]

IF STRM[4,1) = 8 THEN OFFER_BALANCE 0

 

[MsSamson]

Thank you. That works.