Skip to Content
0

Data Masking for the part of the field text.

Nov 28, 2016 at 05:37 AM

114

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Denise Meyer
Nov 28, 2016 at 04:50 PM
0

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

Thanks,
Denise Meyer

SAP Support.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 29, 2017 at 04:27 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 31, 2017 at 10:51 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded