09-19-2024 12:30 AM
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'?
Solved! Go to Solution.
09-19-2024 05:59 AM
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,
09-19-2024 05:59 AM
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,
09-20-2024 01:24 AM
Much appreciated. I have signed up for the DemandTools Formula training. I am sure I will learn alot there.
Get industry news, expert insights, strategies, and hot tips, served up fresh every week.
Visit the Validity blog