Apr 15, 2022 09:23 AM
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
Apr 15, 2022 03:18 PM
Hi,
that should work. change FieldName and you can also experiment with HR. VALUE(TRIM(REGEX_EXTRACT(REGEX_EXTRACT({FieldName},“HR. *\w+”)," \w+")))
Apr 16, 2022 04:50 PM
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:
