Filter values based on the structure of a value

Is there a way to filter for values as follows.

Typically, the values in a column should be of the format


but very occasionally a data entry error occurs where the entry will be of the format


so I want to be able to filter for only entries that start with "C" and then have 15 numbers after it.

You can use an expression like that:

NOT (startswith([Column], "C") AND isnumeric(mid([Column], 2, 15)))
1 Like