This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.
I would love it if Airtable had a formula to determine whether a string (or field reference containing a string) matched a given regular expression.
Google Sheets, for example, has the REGEXMATCH() function. It takes a string/cell reference and a regex, and returns TRUE or FALSE based on whether a match is found.
This would be immeasurably useful. A couple ideas:
Some of these are possible now with complicated sequences of FIND, LEFT, MID, RIGHT, and LEN. It’s hard to debug formulas built this way, however. Regex is compact, easy to test, and comparatively easier to read.
Adam from the Airtable support team here. We now have REGEX functions available for use in formula fields. You can find some more information about those functions in this support document.
This announcement would have been welcome as a standalone post as well, and not just a comment on a thread that only some will see.