Alteryx Designer Desktop Discussions

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

RegEx

tessaenns
9 - Comet

I would like to try and create a reg ex formula for the following pattern...

 

0000-00-00_PS5_Play_Station.xlsx

 

where the zeros above can be any number between 0-9 any field that do NOT follow that pattern  is discarded.

 

I'm curious to see what the community comes up with so I can compare your solution with my initial first try.

 

Thanks for any and all help!

4 REPLIES 4
fmvizcaino
17 - Castor
17 - Castor

Hi @tessaenns ,

 

Here is a suggestion. \d{4}-\d{2}-\d{2}_PS5_Play_Station.xlsx

fmvizcaino_0-1592249345795.png

 

 

Best,

Fernando Vizcaino

 

 

tessaenns
9 - Comet

Thank you! for your quick reply, that worked! The only thing I did differently was use the formula tool instead of the reg ex tool to create a match pattern statement.

 

Thanks again!

Thableaus
17 - Castor
17 - Castor

@tessaenns 

You can also use a Filter Tool directly with the REGEX_Match function.

 

REGEX_Match(Field, "\d{4}-\d{2}-\d{2}_PS5_Play_Station.xlsx")

 

The true side would give you the desired results.

 

Cheers,

Thableaus
17 - Castor
17 - Castor

@tessaenns 

 

Also, if you want to potentially improve performance you can split your column in two and use REGEX just where it matters the most.

 

Thableaus_0-1592258525950.png

 

 

REGEX is resource intensive, so be careful when dealing with millions of records.

 

Cheers,

Labels