Jan 18, 2023 05:06 AM
I wish Airtable Regular expressions followed some common flavours so we could test it with regex101.com
I can make it work in these builders, but then when it comes back to Airtble #ERRROR. It's a huge potential but otherwise Airtable makes it hard to figure out why it isn't working.
I am trying to pull out the Patient's name from a Text extract. It always occurs after "Patient's name: " & before "Birthdate:"
Radiology Report Patient’s name: Barney (57493) Birthdate: 7/5/2013
One Regex101.com, and regextester.com I can get it perfectly with this regex:
(?<=name: )(.*)(?= Birthdate: )
But when I put that in airtable:
Jan 18, 2023 05:44 AM
Jan 18, 2023 05:55 AM
Airtable REGEX formula functions are based on Google's RE2 library, which does not support the before/after features you are trying to use, among other things. It is the same library that Google Sheets uses.
If you stick to "simpler" regex expressions you should be okay.
Apr 06, 2023 07:10 AM
Something as simple as this fails in Airtable:
very frustrating indeed