Need to take result values in 2 OBX05 fields and concatenate to the OBX04.

[Linda O.]

Softbank to Epic BPAM – ORU^R01 – taking the value of OBX05, if OBX03.1 is UNITN and taking the value of OBX05, if OBX03.1 is UNPRD, then take the two results and concatenate to the OBX04 field.

How would I go about checking the segments for the 2 result values needed,  concatenate the values and then make sure they are valued in OBX04 for each segment in that grouping?

Here is what the end result should look like.

Group one

OBX|1|ST|UTYPE^HUMAN READABLE UNIT ABO^SOFTLRR^^^LN| W036311000001- E0336V00|O||||||P|||201911141416||BCH1

OBX|2|ST|URH^HUMAN READABLE UNIT RH^SOFTLRR^^^LN| W036311000001- E0336V00|NEG||||||P|||201911141416||BCH1

OBX|3|ST|UPROD^HUMAN READABLE PRODUCT CODE^SOFTLRR^^^LN| W036311000001- E0336V00|E0336V00||||||P|||201911141416||BCH1

OBX|4|ST|UNITN^UNIT #^SOFTLRR^^^LN| W036311000001- E0336V00|W036311000001||||||P|||201911141416||BCH1

OBX|5|ST|USTAT^UNIT STATUS^SOFTLRR^^^LN| W036311000001– E0336V00|selected||||||P|||201911141416||BCH1

OBX|6|ST|UBPRD^BARCODED PRODUCT CODE^SOFTLRR^^^LN| W036311000001- E0336V00|E0336V00||||||P|||201911141416||BCH1

OBX|7|ST|UBTYP^BARCODED ABORH^SOFTLRR^^^LN| W036311000001- E0336V00|=%9500||||||P|||201911141416||BCH1

OBX|8|ST|UEXP^UNIT EXPIRATION^SOFTLRR^^^LN| W036311000001- E0336V00|201911302359||||||P|||201911141416||BCH1

Group two

OBX|9|ST|UTYPE^HUMAN READABLE UNIT ABO^SOFTLRR^^^LN| W036399111822- E0224V00|O||||||P|||201911201114||CGP1

OBX|10|ST|URH^HUMAN READABLE UNIT RH^SOFTLRR^^^LN| W036399111822- E0224V00|NEG||||||P|||201911201114||CGP1

OBX|11|ST|UPROD^HUMAN READABLE PRODUCT CODE^SOFTLRR^^^LN| W036399111822- E0224V00|R12||||||P|||201911201114||CGP1

OBX|12|ST|UNITN^UNIT #^SOFTLRR^^^LN| W036399111822- E0224V00|W036399111822||||||P|||201911201114||CGP1

OBX|13|ST|USTAT^UNIT STATUS^SOFTLRR^^^LN| W036399111822- E0224V00|selected||||||P|||201911201114||CGP1

OBX|14|ST|UBPRD^BARCODED PRODUCT CODE^SOFTLRR^^^LN| W036399111822- E0224V00|E0224V00||||||P|||201911201114||CGP1

OBX|15|ST|UBTYP^BARCODED ABORH^SOFTLRR^^^LN| W036399111822- E0224V00|=%9500||||||P|||201911201114||CGP1

OBX|16|ST|UEXP^UNIT EXPIRATION^SOFTLRR^^^LN| W036399111822- E0224V00|201912152359||||||P|||201911201114||CGP1

 

 

Topic

[Jim Kosloskey]

Do you want to do this in an Xlate?

Are you saying on the input one segment will have an OBX-3.1 value of ‘UNITN’ and a different input OBX segment will have an OBX-3.1 value of ‘UBPRD’?

Then take the OBX-5.1 field of the 2 input OBX segments and concatenate the values together and place in the OBX-4.1 field of each of those OBX segments or in every OBX segment in the ‘group’?

Apparently the OBX-4 is being used to logically Group the OBX segments together. How does one determine the ‘Group’ has changed in the input?

I suspect there could be more questions to be answered before a solution is derived but I think this can be accomplished within an Xlate with little or no Tcl involved.

I would be willing to work through this with you if you like. Just email me (see my email address below) and I will assist the best I can.

 

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Author]

Replies