web stats
Mirth Community - View Single Post - Combine multiple OBX fields into one by removing carets ^
View Single Post
  #1  
Old 05-27-2014, 12:08 PM
Jaypell22 Jaypell22 is offline
OBX.1 Kenobi
 
Join Date: Jul 2011
Location: Upstate NY
Posts: 33
Jaypell22 is on a distinguished road
Default Combine multiple OBX fields into one by removing carets ^

I have done some digging and havent come accross anything that works specific to this.

I need to remove the carets and make each field show up in OBX.5.1 separated by a comma. There is no telling how many total fields there will be or how many OBX lines will contain the carets so I need to check all lines.

I am looking to take an obx line shown here:

OBX|24|TX|ID^Chief complaint:||C/O SOB, COUGH, CP^14.3 MCI 133XE^4.9 MCI 99MTC MAA^PTINJECTED: RT WRIST IV

And make it look like this:

OBX|24|TX|ID^Chief complaint:||C/O SOB, COUGH, CP,14.3 MCI 133XE,4.9 MCI 99MTC MAA,PTINJECTED: RT WRIST IV




Thank you!
Reply With Quote