How to separate part of a field

Highlighted
Level 2

How to separate part of a field

Hello Marketo Community!

In our CRM, we track phone numbers in two fields: Area Code and Phone Number. We are in the process of integrating our text messaging program with Vibes and are running into difficulty because Vibes maps their phone numbers with the Mobile Phone Number field, housing both the area code and the phone number in one field. Is it possible to separate the two, so we can have the area code in one field and the phone number in another? We've asked both Marketo and Vibes, and each is saying that they cannot do it from their end.

Thanks for the help!

3 REPLIES 3
Highlighted

Re: How to separate part of a field

Hi Sarah,

Use a webhook platform. They are very good at doing this. Search the Launchpoint for these solutions.

-Greg

Highlighted
Level 10 - Community Moderator

Re: How to separate part of a field

Love full-fledged webhook platforms but for phone data in particular, you can call the Twilio lookup API as webhook to parse and identify numbers, then map results back into individual fields. See here: Calling the Twilio Lookup API as a Marketo webhook

Highlighted

Re: How to separate part of a field

Hi Sandy,

Thx for the pointer to the post that I had missed.

-Greg