Scenario:
Result of a saved Contact search shows the Customer ID/Number instead of merely the Company Name.
Solution:
- Navigate to Lists > Search > Saved Searches
- Click Edit on Saved Contact Search
- Click Results
- Field:
- Select Company Field
- Click Remove
- Select Formula (Text)
- Formula: Enter REGEXP_SUBSTR({company}, ‘(s)(D*)’)
- Click Save & Run