Regex_Match/Regex_Parse Query

Hi,

I hope someone can help as I have searched the community and none of the solutions provided appears to work. I have a string field of the format below

2026-03-11 12:00RACEDAY

What Im trying to do is search for date using filter and true/false. This will filter out all fields with this format, then I need to parse date and time. The "raceday" word is not common across all the fields.

Any help would be much appreciated.

Thank you

Developer

Developer Tools

Date Time

Accepted answers

binu_acs

@fieldew1 try

Filter_12032026.yxmd

All comments

fieldew1

I have tried this combination with no success

if REGEX_Match([logo],"\d{4}-\d{1,2}-\d{1,2}") then "True"
else "False" endif

OTrieger

@fieldew1
Basically what you need to do is to isolate the date from the rest of the string, there are several ways how to do it. RegEx is one of them, you can use Text to Columns using the space as delimiter, there are sting formulas such as Left, etc. use anyone that you are most familiar with, then when you have the date isolated, covert the data to date type. When you achieve that then the matching will be easy.

binu_acs

@fieldew1 try

Filter_12032026.yxmd

fieldew1

Thank you @binu_acs for this. It seem like it has worked. If I wanted to regex date and time only, what this would look like ?

fieldew1

Thank you @OTrieger, I did find a way around it eventually using a formula but Regex seems like the best solution, hence, it was my question. Regex is probable one of the least understood functions by me.

binu_acs

@fieldew1 attaching the workflow

Filter_12032026.yxmd

fieldew1

@binu_acs amazing! Thank you! Do you have any known resources so I could understand Regex function better ? many thanks Ewa

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703