Data tools like Openprise could do this.
Alternatively, you can export this to Excel, run the split, then re-upload. This assumes no dupes.
I've noticed you mention Openprise on a couple of data management threads. Are you using this tool? Do you personally recommend it?
There are tools like Openprise, RingLead, LeanData that allow diff kinds of complex data processing.
Based on demos, I do like Openprise. Depends on what you need to do.
If you are able to do webhooks, that's a good low cost option. I believe someone setup a low cost webhook tool for marketo somewhere. Or you can use zapier instead.
1 of 1 people found this helpful
A webhook can do this fixup very easily. If it always uses the format in your example, it's a simple regex replacement. For example, in Java (though this could be written in any modern language):
phoneNumber = phoneNumber.replaceFirst("\sx\d+$","");
You can also use the free Twilio lookup API for this (see Calling the Twilio Lookup API as a Marketo webhook). The phone_number property in the response is always the phone number without the extension. The only difference is that it uses (as is technically proper) the E.164 version of the number, with a + prepended.