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

[Anonymous]

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

[Alok_Ramsisaria]

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?

[Anonymous]

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]

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