Convert phone number field to a default format in AD via Powershell

All replies

• 

  

  0

  Sign in to vote

  I moved your question to a more appropriate forum.

  ---

  Richard Mueller - MVP Enterprise Mobility (Identity and Access)

  Thursday, July 12, 2018 12:43 PM
• 

  

  0

  Sign in to vote

  You will have to parse the string and change it to what you need.

  You can start with removing the opening

  ($number -replace '^+45|45') -replace ' '

  Now you are left with the remaing 8 digits so split them and add it all back together:

  '+45 {0} {1}' -f $first4,$last4

   

  ---

  \_(ツ)_/

  
  

  • Edited by jrv Thursday, July 12, 2018 12:50 PM
  • Proposed as answer by Richard MuellerMVP Thursday, July 12, 2018 1:27 PM

  Thursday, July 12, 2018 12:49 PM
• 

  

  0

  Sign in to vote

  You will have to parse the string and change it to what you need.

  You can start with removing the opening

  ($number -replace '^+45|45') -replace ' '

  Now you are left with the remaing 8 digits so split them and add it all back together:

  '+45 {0} {1}' -f $first4,$last4

   

  ---

  \_(ツ)_/

  
  

  Some of those numbers have space(s) separating the two four-digit groups. Here's another way to accomplish the reformatting:

  $x = $number -replace '(?:\+?45)?\s?(\d{4})\s?(\d{4})', '+45 $1 $2'

  The first group "(?:\+45|45)?" is non-capturing, and optional. All the spaces (\s?) are also optional.
  

  ---

  --- Rich Matheisen MCSE&I, Exchange Ex-MVP (16 years)

  
  

  • Edited by Rich Matheisen [Ex-MVP (retired)] Thursday, July 12, 2018 9:19 PM Simplified 1st group to avoid unnecessary 'or' condition

  Thursday, July 12, 2018 6:37 PM