How to Remove Customer Number on Contact Search

Scenario:

Result of a saved Contact search shows the Customer ID/Number instead of merely the Company Name. 

Solution:

  1. Navigate to Lists > Search Saved Searches 
  2. Click Edit on Saved Contact Search 
  3. Click Results
  4. Field: 
  5. Select Company Field
  • Click Remove 
  1. Select Formula (Text) 
  • Formula: Enter REGEXP_SUBSTR({‌company}, ‘(s)(D*)’)
  1. Click Save & Run 

Leave a comment

Your email address will not be published. Required fields are marked *