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.