Concatenate Multiple NTE-3’s From Multiple Segments Into A Single OBR field

[Jonathan Souders]

I have a need to concatenate multiple order comments from multiple NTE’s into a single OBR field.

Has anyone ever done so using an xlate? Would it just make sense to use a proc in this instance? I can’t find a way to append a temp variable so I wasn’t sure if this would be possible in the xlate or not.

 

I was trying to avoid using a proc, if I could, mostly just to say I did it – so I don’t have a hard line saying I can’t use Tcl for it. Just curiosity!

 

Thanks.

Topic

[Paul Bishop]

It can be done in a translate.  You would use a temp variable to save the information before moving it to the OBR field.  Make sure the temp variable is initialized first (move @null into it at the top of the Xlate), then in the loop for the NTE segments, you would have the NTE field and the temp variable as the source, use the CONCAT action, and the temp variable as the destination.  If you want to have something between the fields, use the “Separator” field on the CONCAT properties.

Paul Bishop
Carle Foundation Hospital
Urbana, IL

[Jonathan Souders]

I JUST figured it out right before coming back to see if anyone had commented. Hah!

Thanks for your help though, Paul. This would have saved me some headache if I would have just waited.

[Author]

Replies