Filter Contains date within string

Question

I am trying to filter out rows that contain date in a string, String field examples are:

"asdfjkl 10/10/2"

"asdfjkl10/10/20"

"asdfjkl.00001"

I want to filter out the first two but not the last one

I tried using regex_match with "d{2}\{2}" as well as (*) similar to in python re but the filter did not work.  Should I be using something else like a formula to do this?

AngelosPachis · Accepted Answer

Hi @kshah23 ,

If you want a RegEx solution then try

REGEX_Match([Field_Name], ".*\d{2}\/\d{2}\/\d+")

Regards,

Angelos