Hi everybody,

I'm trying to create masking policy for email and phone colum in my database. I use this regular express :

• Email : ([a-zA-Z0-9][\w\_\.]{0,30})\@([a-zA-Z0-9.-]+)\.([a-zA-Z]{2,4})
• Phone Number : (09|01[2|6|8|9])+([0-9]{8})\b - formart of mobilephone number in my country is 10 numbers and start with 09 or 01.

The Regex is match data in email and phone columns but the return data is replace all by *. What i expect is somethings like :

• Original email data : quanglnh@gmail.com then the return data is qu******@gmail.com

• Original phone data : 0986234358 then the return data is ******4358

I don't see the option to allow us choose how many character to be replace.
Please kindly help me if you have any idea, thanks!

------------------------------
Quang Le Nguyen Hong
------------------------------

Hi all,
I was do some searching and findout it all about how you define your Regular Express and below is how i do :

• Email : ([a-zA-Z0-9][\w\_\.]{0,5})\@([a-zA-Z0-9.-]+)\.
• Phone : (^0[1|2|3|4|5|6|7|8|9])+([0-9]{5})

------------------------------
Quang Le Nguyen Hong
------------------------------

Original Message:
Sent: Wed January 08, 2020 10:22 PM
From: Quang Le Nguyen Hong
Subject: Masking a part of return data

Hi everybody,

I'm trying to create masking policy for email and phone colum in my database. I use this regular express :

• Email : ([a-zA-Z0-9][\w\_\.]{0,30})\@([a-zA-Z0-9.-]+)\.([a-zA-Z]{2,4})
• Phone Number : (09|01[2|6|8|9])+([0-9]{8})\b - formart of mobilephone number in my country is 10 numbers and start with 09 or 01.

The Regex is match data in email and phone columns but the return data is replace all by *. What i expect is somethings like :

• Original email data : quanglnh@gmail.com then the return data is qu******@gmail.com

• Original phone data : 0986234358 then the return data is ******4358

I don't see the option to allow us choose how many character to be replace.
Please kindly help me if you have any idea, thanks!

------------------------------
Quang Le Nguyen Hong
------------------------------

Guardium is compliant with 1003.2 standard

------------------------------
Zbigniew Szmigiero
IBM
Warsaw
------------------------------

Original Message:
Sent: Wed January 08, 2020 10:22 PM
From: Quang Le Nguyen Hong
Subject: Masking a part of return data

Hi everybody,

I'm trying to create masking policy for email and phone colum in my database. I use this regular express :

• Email : ([a-zA-Z0-9][\w\_\.]{0,30})\@([a-zA-Z0-9.-]+)\.([a-zA-Z]{2,4})
• Phone Number : (09|01[2|6|8|9])+([0-9]{8})\b - formart of mobilephone number in my country is 10 numbers and start with 09 or 01.

The Regex is match data in email and phone columns but the return data is replace all by *. What i expect is somethings like :

• Original email data : quanglnh@gmail.com then the return data is qu******@gmail.com

• Original phone data : 0986234358 then the return data is ******4358

I don't see the option to allow us choose how many character to be replace.
Please kindly help me if you have any idea, thanks!

------------------------------
Quang Le Nguyen Hong
------------------------------