REGEX Formula for extracting a number after a string

+2

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

+25

Hi,

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

+2

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:

Sign up