How to Mask variable length strings using a separator

[Krushna padhy]

Hi,

 

We are masking one column in oracle which has values separated by one " | " (ID | COMPANY NAME).we want to mask both parts separably using FDM .Is there any function we can use ?

 

Regards,

Krushna

[Anil Kumar Appukuttan]

If you are on TDM 4.5, then you could use the From Occurrence and To Occurrence fields in FDM where you can specify a delimiter for a particular field.

 

So for e.g. to mask the first field in the delimited column you would use the masking rule and set the From Occurrence to Blank and To Occurrence to 1(|) and to mask the second field you would use 1(|) and 2(|) respectively.

[Krushna padhy]

Hi Anil,

 

Thank you ,its really help full . I am able to mask now .

 

Regards,

Krushna

[Krushna padhy]

Hi Anil,
I am applying same logic while masking excel file but its not working :(  , any idea ' From Occurrence and To Occurrence ' supports in Excel also ?

Thanks,
Krushna