Data Masking for the part of the field text.

[venkataramana_paidi]

Hi ,

I have one requirement for data masking. I have one varchar(255) field. I am getting some long text. In the long text may contain some sensitive information like phone numbers or account numbers or email addresses.

I want to mask only sensitive part in the string.

Example: John is loyal customer and his email is : abcd@live.com

An output should be like : John is loyal customer and his email is : xxxx@live.com

The above whole text in the single field but I want to mask only email address only.

In DS, we have a data masking transform which applicable to whole input field not the part of the field data right?

Could you please help me to achieve using SAP DS data masking transform.

Thanks & Regards,

Ramana.

[former_member198401]

Ramana

You can refer to below link. I hope your DS version is above SP04. This will be perfect for your requirement.

https://blogs.sap.com/2015/04/10/mask-functionality-in-ds-42-sp-04/

Regards

Arun Sasi

[venkataramana_paidi]

Hi Denis,

Thanks for your response. But search replace functionality is not equivalent to the masking right?

We can achieve mask out feature but not the number variance or date variance. Again in the mask out also difficult maintain the maintain formatting feature. We need to write more code using custom functions.

Thanks & Regards,

Ramana.

[denise_meyer]

You could use search/replace functionality to acheive this as well.

Thanks,
Denise Meyer

SAP Support.