Filter values based on the structure of a value

1

Is there a way to filter for values as follows.

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

abcd_8hdmnh9f09isdhj

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

C123456789012345

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

2

You can use an expression like that:

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