I am trying to check the Number of records that do not comply with std format (XX-XXXXXXX) within a specified field.
Any help is greatly appriciated !
Page 1 / 1
Hello,
in order to count the numer of cases that do not match a specific format, you can use the following formula:
SUM(CASE WHEN table.column LIKE __-_______ THEN 0.0 ELSE 1.0 END)
The _ (underscore) is a placeholder for exactly one placeholder.
I hope this solves your problem.
Cheers,
Florentin
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.