![Ali_Al-Rasheed Ali_Al-Rasheed](https://community.airtable.com/legacyfs/online/avatars/2X/8/8eeb8139b71e4d0dc164fcc510c433840a676dfa.png)
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
2 Replies 2
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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+")))
Reply
![Ali_Al-Rasheed Ali_Al-Rasheed](https://community.airtable.com/legacyfs/online/avatars/2X/8/8eeb8139b71e4d0dc164fcc510c433840a676dfa.png)
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- 130/62 HR:75 oxygen: 97%
- BP-150/69,HR-65b/m,SPO2-99%
- 158/67 ,HR68,SpO2 98
![](/skins/images/FE00829FDD2AE889FAB731D8F02A8942/responsive_peak/images/icon_anonymous_message.png)