I would like to be able to use regex to match values in formulas. Both in views and ETLS Such as this. I am using this to validate some data in a view formula
CASE
when `Field` like '[0-9]{4}\-[0-9]{4}\-[0-9]{3}' then 0
when `Field` = '' then 0
else 1
end