Filter Contains date within string

[kshah23]

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?

[pedrodrfaria]

Hi @kshah23 

If you want a simple one without regex you can do a !contains([Field], "/") in the filter tool.

If you want to use the data structure, you can use a  !REGEX_Match([Field1], ".*\d*/\d*/\d*.*") in the filter tool.

Let us know if you have any questions regarding this solution.

Pedro.

[AngelosPachis · Accepted solution]

Hi @kshah23 ,

If you want a RegEx solution then try

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

Regards,

Angelos