stringdecode Function

[rxs0005]

hi

i am using this in the transformer

StringDecode( tpo_loan_orig_out.OCCUPANCY , 'O= OwnerOccupied|N =Non Owner Occupied| S= Second home ' )

but when the input is O its not decodign to OwnerOccupied as i am gettgin the below inf in the log file

bnk_ld_gmacb_loan_orig..xfm_bank_tpo_loan (StringDecode): Invalid lookup for - O

can some one help me with this

thanks

rxs0005

[kcbland]

Get rid of the spaces before and after the "=" sign as well as the code value, it messes up the logic. It works only if it looks like this:

Code: Select all

 'O=OwnerOccupied|N=Non Owner Occupied|S=Second home'

You really should be more careful, this is fairly sloppy coding, IMO.