REGEX Formula for extracting a number after a string

[Ali_Al-Rasheed]

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

[Alexey_Gusev]

Hi,

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

[Ali_Al-Rasheed]

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