web stats
Mirth Community - View Single Post - Extract data from a single OBX segment based on word separators
View Single Post
  #1  
Old 10-29-2013, 12:56 PM
Jaypell22 Jaypell22 is offline
OBX.1 Kenobi
 
Join Date: Jul 2011
Location: Upstate NY
Posts: 33
Jaypell22 is on a distinguished road
Default Extract data from a single OBX segment based on word separators

I am trying to figure out how to extract exam descriptions from an ORU message that will sometimes be separated by "and" or "\T\". The field will not always be on the same OBX line however will always follow "EXAM:" in OBX.5.1. There can be as many as 3 exam descriptions. I need to insert them into a MySQL database after separated. If it's easy to move them each into separate OBR fields I can then easily move them to the MySQL database.

Any assistance would be greatly appreciated.

For the examples below I am looking to get 3 separate entries
CT abdomen without contrast
CT pelvis without contrast
CT chest without contrast

Examples:


OBX|7|ST|||EXAM: CT abdomen without contrast and CT pelvis without contrast and CT chest without contrast||||||P||||||
OBX|8|ST|||||||||P||||||

OBX|7|ST|||EXAM: CT abdomen without contrast \T\ and CT pelvis without contrast \T\ CT Chest without contrast||||||P||||||
OBX|8|ST|||||||||P||||||
Reply With Quote