How to replace part of a phone number

[Gerard_Spijker]

In our CRM system phone numbers need to be entered in the internal format, like: +31629333422. But often this is entered as: +310629333422. So with the zero after +31. 

I am thinking of using the Modify function of DemandTools. So I can look for all phone numbers that I start with +310. But now how do I get Demand tools only to replay the first part of the phone number '+310', to '+31'?

[AnthonyValidity · Accepted solution]

Hi @Gerard_Spijker ,

The simpliest way I can think of to accomplish this is to use a substitue formula:

SUBSTITUTE(${Phone}, "+310", "+31")

It is fairly straightforward since they all start with the same substring.  

Regards,

[Gerard_Spijker]

Much appreciated. I have signed up for the DemandTools Formula training. I am sure I will learn alot there.