4 Replies Latest reply on Aug 13, 2018 2:20 PM by Josh Hill

    Erase extensions from Phone field

    Sam Sweeney

      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.

       

      Ex:

      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.