Truncate Number at the Beginning of the Company Name on Contact Record

Scenario

Truncate the Company field on the Contact record to remove any numbers present on the Company field value

Solution

1. Create an Entity Field
1. Navigate to Customization > Lists, Records, & Fields > Entity Fields > New
2. Label: Enter Label
   Example: Truncated Company Value
3. Type: Select Free-Form Text
4. Store Value: Remove Checkmark
5. Click Applies To tab
• Contact: Enter Checkmark
6. Click Display tab
• Subtab: Select Main
7. Click Validation & Defaulting tab
• Formula: Enter Checkmark
• Default Value: Enter REGEXP_REPLACE({company},'1|2|3|4|5|6|7|8|9|0', '')
8. Click Save