Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parsing Blood Pressure Values 1

Status
Not open for further replies.

tsimsnh

Programmer
Mar 15, 2006
6
US
I have a column that lists out combined blood pressures that contain data such as this: 130/80, 98/110, 130/100, 98/80. Using CRXI, I need to parse out the systolic (On the left side of the /) and diastolic (on the right side of the /). Specifically, I need to highlight the blood pressures that have a systolic value greater than or equal to 130 or a systolic value greater than or equal to 80. Any ideas on parsing the 2 or 3 digit systolic and diastolic values consistently?
 
Off the top of my head, you could try using the SPLIT function with the comma then the forward slash as the delimiter.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top