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!
Solved! Go to Solution.
Hi @tessaenns ,
Here is a suggestion. \d{4}-\d{2}-\d{2}_PS5_Play_Station.xlsx
Best,
Fernando Vizcaino
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!
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,
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,