Skip to main content

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+")))

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


Reply


Terms & Conditions