Page 1 of 1

Mask a number Batch replace Reg Expression

Posted: Thu Aug 23, 2007 8:44 pm
by bond007
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?

Re: Mask a number Batch replace Reg Expression

Posted: Thu Aug 23, 2007 8:48 pm
by Abacre
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.

Re: Mask a number Batch replace Reg Expression

Posted: Thu Aug 23, 2007 8:52 pm
by bond007
Awesome. Thanks for your promt reply boss. Ticket closed :D