Discussions
NSC | Saved Search Formula to Identify Specific Format of Phone Numbers
Scenario
User needs to identify customer records where the phone numbers stored in a NetSuite field do not adhere to the format "###-###-####".
This might happen due to manual data entry errors, lack of data validation and/or changes in formatting standards.
Solution
Use the REGEXP_SUBSTR function to check if the format is correct.
Formula (Text): CASE WHEN REGEXP_SUBSTR({phone}, '^\d{3}-\d{3}-\d{4}$') IS NULL THEN 'Invalid Format' ELSE 'Valid Format' END
Note: Depending on your requirement, you can add this formula as a filter in the Criteria, as a column in the Results, or as a condition in Highlighting.
Learn how to Refer A Member | Earn the Answer Accepter Badge | Be the Content Creator of the Quarter | Vote for the content you want to see!
