hi
i have about 100 files, and want to mask the customer number, as follows:
original:
<customer_number>123456789012</customer_number>
desired result:
<customer_number>********9012</customer_number>
I want all but last 4 digits to change to asterisks. Customer number is always 12 digits.
Can someone please help?
Mask a number Batch replace Reg Expression
Re: Mask a number Batch replace Reg Expression
Go to main menu - Action - Options - Batch Replace
check "Modifier M"
uncheck "Modifier S"
uncheck "Modifier G"
Go to Batch replace tab, check on "Use regular expressions".
Put into the grid:
Search for:
<customer_number>\d+(\d{4})</customer_number>
Replace with:
<customer_number>********$1</customer_number>
That's all I verified it works perfectly.
check "Modifier M"
uncheck "Modifier S"
uncheck "Modifier G"
Go to Batch replace tab, check on "Use regular expressions".
Put into the grid:
Search for:
<customer_number>\d+(\d{4})</customer_number>
Replace with:
<customer_number>********$1</customer_number>
That's all I verified it works perfectly.
Re: Mask a number Batch replace Reg Expression
Awesome. Thanks for your promt reply boss. Ticket closed