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:"
Example string:
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:
REGEX_EXTRACT({PDF Text Extraction}, "/(?<=name: )(.*)(?= Birthdate: )")
I get a big fat #ERROR
I know it's me but can anyone point me int he direction of a regex tester that is compatible with Airtable?
Or tell me what I can use here?
Or tell me what I can use here?
