AnsweredAssumed Answered

How to mask substring from the given string in mainframe file

Question asked by kamalakannan on Mar 22, 2018
Latest reply on Apr 4, 2018 by BillyKeefer
I am trying to mask two free text Fields in a Mainframe File which can have value something like 'SSN 123456789 ' or ' SSN 123456987 ', etc.
I want to mask only the rows which has the text 'SSN' in it as part of the Free text column and leave the other rows unmasked.

I am trying to use the Where condition in the Transformation maps, but Unfortunately i am not getting proper results.

Ideally main focus here is on the Substring search within a field.

Could someone please let me know how to USe substring search in the transformation maps, A sample template would be much helpful.

Outcomes