Powershell Script Output Not as Expected

Question

I've adapted a RegEx to normalize phone numbers, source: http://www.regexplanet.com/cookbook/pho ... index.html.

Import-Module Adaxes
$identity = "%sAMAccountName%"
$mobileNumber = '%mobile%' -ireplace '\D*([2-9]\d{2})(\D*)([2-9]\d{2})(\D*)(\d{4})\D*', '+1 ($1) $3-$5'
Set-AdmUser -Identity $identity -MobilePhone "$mobileNumber"

Testing in the Powershell IDE works perfectly on all phone numbers I gave it. However, when running on numbers formatted at +1 (888) 555-5555, adaxes returned +1+1 (888) 555-5555.

Any guidance on this?

Comments

I fixed the problem by escaping the input with:

see below.

---

Spoke before I actually tested in adaxes...

The function works once you move the escape to the input as follows:

Import-Module Adaxes  

$identity = "%sAMAccountName%"  

$mobileNumber = \[Regex\]::Escape('%mobile%') -ireplace '\\D\*(\[2-9\]\\d{2})(\\D\*)(\[2-9\]\\d{2})(\\D\*)(\\d{4})\\D\*', '+1 ($1) $3-$5'  
Set-AdmUser -Identity $identity -MobilePhone "$mobileNumber"

If anyone has any suggestions on improving efficiencies, please post.

Thanks!

Answer 1

Hello,

The thing is that \D* (non-digits) doesn't include a sequence of characters that contain a plus (+) sign. So, to resolve your issue, you simply need to replace the starting and ending \D* with .* (matches any character). In this case, your zero-level character class will include all characters in the string. The resulting regular expression is as follows:

.*([2-9]\d{2})(\D*)([2-9]\d{2})(\D*)(\d{4}).*

In this case, you don't need to escape anything, just call -ireplace on the value returned by %mobile%:

Import-Module Adaxes

$identity = "%sAMAccountName%"

$mobileNumber = '%mobile%' -ireplace '.*([2-9]\d{2})(\D*)([2-9]\d{2})(\D*)(\d{4}).*', '+1 ($1) $3-$5'
Set-AdmUser -Identity $identity -MobilePhone "$mobileNumber"