REGEX Formula for extracting a number after a string

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

Hi,

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

1 Like

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.