Regex in Formulas in Views and in Formula ETL Tiles

Options
Byboth
Byboth Contributor
edited January 8 in Magic ETL Ideas

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

Tagged:
4
4 votes

Active · Last Updated