RegEx_Replace

Hi there,

I am quite new to regex and coding, and alteryx in general, so I ask the community for some help

I have a field containing 11 digit numbers. However, I would like to replace the 5 last digits with X as these digits represent personalized ID numbers.

So lets say I have this number "123456789123", but i want it to becoem 123456XXXXX

I have tried: RegEx_Replace ([field1], "\d{11}", "\d{6}\wXXXXX"), this did not work.

I would appreciate any help I could get

Kind regards

Regex

Accepted answers

jdunkerley79

Try:

RegEx_Replace ([field1], "(\d{6})\d{5}", "$1XXXXX")

This will match 11 numbers in a row and save the first 6 into $1.

It will then replace all 11 with the first 6 then 5 Xs

All comments

jdunkerley79

Try:

RegEx_Replace ([field1], "(\d{6})\d{5}", "$1XXXXX")

This will match 11 numbers in a row and save the first 6 into $1.

It will then replace all 11 with the first 6 then 5 Xs

olehr

Thank you so much, that worked perfectly

However, one question. You started with "( Why the quote outside the parenthesis? And for that matter, why the parenthesis in the first place ?

Stupid question from a nubie

Kind regards

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335