Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filter Contains date within string

kshah23
5 - Atom

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?

2 REPLIES 2
pedrodrfaria
13 - Pulsar

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.

 

pedrodrfaria_0-1609865655416.png

 

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

 

Pedro.

AngelosPachis
16 - Nebula

Hi @kshah23 ,


If you want a RegEx solution then try

 

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

 

Regards,

 

Angelos

Labels