I want to standardize my Mobile Number field to just the 10-digit of the phone number.
Is there a way to use two different Smart Campaigns?
- IF Mobile Number Contains '-' >> Write "wrong" data value to a second "To-Be-Cleaned Phone" Custom Field for cleaning
- WHEN "To-Be-Cleaned Phone" Custom Field changes to something >> Write that data, minus the dashes '-' back to the Mobile Number field
Marketo Support suggested I do this by exporting a list, making the corrections in Excel and then re-importing with email address as the de-dupe field. I need this to be automated to ensure a Webhook call can run properly that depends on this Mobile Number field as a token and the POST endpoint only accepts the 10-digit number.
Any ideas of a potential solution that I'm not even aware of?