topic Re: How to replace part of a phone number in DemandTools

How to replace part of a phone number

Gerard_Spijker — Thu, 19 Sep 2024 07:30:15 GMT

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'?

Re: How to replace part of a phone number

AnthonyValidity — Thu, 19 Sep 2024 12:59:04 GMT

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,

Re: How to replace part of a phone number

Gerard_Spijker — Fri, 20 Sep 2024 08:24:13 GMT

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