Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

REGEX Formula for extracting a number after a string

268 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello

I would like to extract a value after “HR” word. This value can be of 2 digits or 3 digits

String:
146/63 HR: 78 oxygen: 98% T: 36.8

2 Replies 2

Hi,

that should work. change FieldName and you can also experiment with HR.
VALUE(TRIM(REGEX_EXTRACT(REGEX_EXTRACT({FieldName},“HR. *\w+”)," \w+")))

It works great but sometimes it returns an error.

It needs a minor adjustment to work with different combinations:

List of strings that returned error for HR value:

  • 130/62 HR:75 oxygen: 97%
  • BP-150/69,HR-65b/m,SPO2-99%
  • 158/67 ,HR68,SpO2 98