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

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

  • Creator
    Topic
  • #114380
    Linda O.
    Participant

      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| W036311000001E0336V00|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

       

       

    Viewing 0 reply threads
    • Author
      Replies
      • #114391
        Jim Kosloskey
        Participant

          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.

      Viewing 0 reply threads
      • You must be logged in to reply to this topic.