Custom filter to only filter if the value begins with '0'

[nfoong]

Hi,

I think the title speaks for itself and it sounds like a regex formula perhaps?

Any explanation of your solution would be great e.g. how regex works that picks up if it begins with 0... Thanks!

Regards,

Nicholas

[MarqueeCrew · Accepted solution]

I will answer without regex.

Left([field],1) = "0"

Cheers,
Mark