Formatting

Question

Dear all,

I have a list of phone numbers, most of them are started with 0 and the other started with the number directly without 0. For example 0547584778 or 547584778 I want the numbers which are not not started with 0 to add the 0 at the beginning. How is it possible?

AngelosPachis · Accepted Answer

Hi @Feras95p ,

You can convert your phone numbers to a string data type and then use a formula tool with the function Padleft.

What this will allow you to do is define the total length of that string (in our occasion that is 10) and the formula will add 0s to the left hand side until the length of that string becomes 10.

So if the input to the tool is this

the output would be

Hope that helps, let me know if that worked for you.

Cheers,

Angelos

AntDavis42 · Accepted Answer

Hi @Feras95p ,

Here is an example that will only add the 0 if the number is 9 digits long and unions the already correct numbers to the filtered options.