RegEx

[tessaenns]

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!

[fmvizcaino · Accepted solution]

Hi @tessaenns ,

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

Best,

Fernando Vizcaino

[tessaenns]

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]

@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]

@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.

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

Cheers,