Through a quirk in our system, we are not permitted to have extensions in the phone field. They must be broken out into a separate "Ext" field. This is an issue for many of our vendors who are unable to append their data to have this broken out into 2 different fields. We have been able to map the extension to the EXt field but now are looking for a way to auto erase the extension from the original phone field.
Incoming data: 555-444-0123 x52
Mapped data: Ext: 52 phone: 555-444-0123 x52
Desired Result: Ext: 52 phone: 555-444-0123
Please let me know if you have a good way to have this field auto remove the extension from the phone field.