Format E.164 telephone number

Question

Hi,

I want to format all existing entries in "telephone number" to the E.164 without exporting and importing a list.

At the moment we have the following formats:

+49123456789 0123456789 +49.123.456.789

It should be by default +49 123 456 789

How can I catch this with a scheduled task?

Thanks

Answer 1

Hello Boris,

There is no possibility to verify/update existing user phones in a business rules as they only trigger when a specific operation is executed. For this purpose, you need to use a scheduled task like the following: In the task condition, use the following regular expression: ^\+[0-9]{2}\s[0-9]{3}\s[0-9]{3}\s[0-9]{3}$.

As for the script, it should take the existing value and format it according to your requirements. If you have issues writing the script, please, specify what should be done in case the property is empty.

To make sure that users cannot enter a phone that does not match the regular expression, you need to adjust your property patterns accordingly. The following tutorial should be helpful: https://www.adaxes.com/help/MakePropertyRequiredAndSpecifyFormat.

Comments

Thanks for your help, I would be very pleased if you could make the script. In case the property is empty, the script should ignore it and simply continue.

---

Hello Boris,

What exactly do you mean by continue? Should the script just exit as there will be no data to use for proper formatting? Maybe it would be best if the script is not executed at all if the property is empty (it can be done using the corresponding condition)?

---

Yes, that would of course be even better. Thanks

---

Hello Boris,

Thank you for specifying. As such, the scheduled task should look like the following: You can find the script below. In the script, the $propertyName variable specifies the name of the property to process. It should be the same one as in the condition.

$propertyName = "mobile" # TODO: modify me

# Get property value as is
$propertyValue = $Context.TargetObject.Get($propertyName)
$propertyValue = $propertyValue.Replace("+","").Replace(" ","").Replace(".","")

if (($propertyValue.Length -eq 10) -and ($propertyValue -like "0*"))
{
    $propertyValue = $propertyValue.Remove(0,1)
}

if ($propertyValue.Length -eq 9)
{
    $propertyValue = "49" + $propertyValue
}

if ($propertyValue.Length -ne 11)
{
    $Context.LogMessage("The value $propertyValue of property $propertyName cannot be formatted as its length does not meet the requirements.", "Warning")
    return
}

# Format property value
$formattedValue = "+" + $propertyValue.SubString(0,2) + " " + $propertyValue.SubString(2,3) + " " + $propertyValue.SubString(5,3) + " " + $propertyValue.SubString(8,3)

# Update the user
$Context.TargetObject.Put($propertyName, $formattedValue)
$Context.TargetObject.SetInfo()

---

Thanks for the script, works great!