Anne Walsh
Member
Members
Forum Posts: 100
Member Since:
May 2, 2014
May 2, 2014
Offline
I've got data that looks like this (all one cell
Original |
* HR 59 <60 Generated at 15:20:38. |
**ABPs 96 <100 Generated at 15:20:32. |
**ABPs 96 <100 Ended. |
**ABPs 96 <100 Generated at 15:20:19. |
* HR 59 <60 Ended. |
**ABPs 82 <100 Ended. |
**etCO2 7.1 >6.8 Ended. |
**etCO2 7.1 >6.8 Generated at 15:19:28. |
* HR 142 >135 Generated at 15:19:08. |
However I want it to look like this.. I can get rid of the Ended bit/Generated at ...bit but how can I separate out the rest of it into the 59 and <60 (note that some of the data will have > instead of <.. I've tried quite a few things but so far no success 🙂 Thanks as always.
Desired | |||
* | HR | 59 | <60 |
** | ABPs | 96 | <100 |
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: steve nastasi, Pam Baillie, Paul Byrne
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1909
SunnyKow: 1432
Anders Sehlstedt: 899
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 279
lea cohen: 245
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Sheila Sanders
Francine Walshe
Sean Ladlow
Jorge Chicas
mahmoud salem
Irvine Choolo
Deon Bouwer
Amgad Squires
jim bo
Linda Bock
Forum Stats:
Groups: 3
Forums: 24
Topics: 6834
Posts: 29981
Member Stats:
Guest Posters: 49
Members: 33568
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —