Skip to main content
August 28, 2015
Question

Remove a zero from a phone number with "change data value"?

  • August 28, 2015
  • 1 reply
  • 1727 views

Hi folks,

does anybody know if there's an option (or a trick) to remove a leading zero from a phone number by using the "Change Data Value" flow step?

Thanks,

Michael

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Level 10
August 28, 2015

Change data value would replace the whole value. We don't have the option to remove parts of values in Marketo. At the most, Marketo Forms have a mask input functionality. Could you share the need for doing so?

August 28, 2015

I want to set up a normalization program that adds a phone number country code to a phone number that hasn't one.

Ex: The phone number of a German lead comes in as "040 12345678". I'd like to make that +49 40 12345678.

I can add the +49 by using an auxiliary field and create flow steps like:

Change Data Value for PHONE_AUX_FIELD to +49 {{lead.PhoneNumber}}

Change Data Value for PHONENUMBER to {{lead.PHONE_AUX_FIELD}}

but that gives me +49 040 12345678

which is incorrect. The first 0 has to go.

And yes, I could do it by adding java script to the form, but we also have leads coming in through other doors than forms.

Josh_Hill13
Level 10
August 28, 2015

Since Regex is not yet available, please do this with Excel. You will damage your data as Alok suggests if you try to do this only in Marketo.

It is easy to export Email Addr | Phone and fix the phone using excel