Vendor Saved Search > Filter Results of Company Name with Multiples Spaces in Name

Scenario

User would like to find all Vendor records with multiples spaces in Company Name (example: Vendor   Sample  Test).

Solution

1. Navigate to List > Search > Saved Searches > New

2. Select Vendor

3. Under Criteria add the following:

- Filter is : Formula (Text)

- Description : is 1

- Formula : CASE WHEN REGEXP_COUNT({companyname}, '\s\s+') > 0 then 1 else 0 end

4. Save