Filter table based on text pattern(Regex)

[cheryl]

Hi,

I have a column of 'Project.name', and I want to create a filter:

If ('Project.name' LIKE '\d{8}*', 'Suspicious', 'OK)

I want to use Regex to match the pattern, however it doesn't work.

The target project names start with 8 digit number. For example, '30294892 XXXX'.

Does anyone know how to achieve this? Thanks very much in advance.

[JGMDataAnalysis · Accepted solution]

If(Len(KeepChar(Left([YourField], 8), '0123456789')) = 8, 'Suspicious', 'OK')