Appending data to the value in a field ?

[Ariba Jones]

I need to append two characters to the end of a value in a field.  Is this something that I can do within an xlate?  Does anyone know how to do this?  For example, the value in the field may be 12;GRANDCHILD.  I need it to go to the receiving system as 12IN;GRANDCHILD.  “IN” is the two-character string I need to append to the end of the numeric value in this field.  

Thanks in advance,

Ariba

Topic

[garry r fisher]

Hi,

You could do it in Tcl in a number of ways using msgset or dat’s and grm’s. What is the message type – HL7?

Garry

[Jim Kosloskey]

Ariba,

Have you tried the CONCAT Action in Xlate?

Jim Kosloskey

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

[Ariba Jones]

Garry this is an HL7 message.

Thanks,

Ariba

[Ariba Jones]

Jim,

I did not try the CONCAT in the xlate.  I will look into that.

Thanks,

Ariba

[Anonymous]

I think this may be what you are trying to do.  Simply use this as a tcl fragment inside the xlate:

set varlist [split $xlateInVals “;’]

set element1 [concat [lindex $varlist 0]IN]

set varlist [lreplace $varlist 0 0 $element1]

set xlateOutVals [join $varlist “;”]

I’m sure there may be a simpler way to do this, but this should be able to get you started.

Thomas G. Rioux

[Jim Kosloskey]

Ariba,

I guess I should have asked rather than assumed.

Is the ; a separator in the message (component separator perhaps)?

If it is CONCAT Action in Xlate will definitely work.

If it is not a separator, then you will need Tcl.

Let me know if you think you need Tcl.

Jim Kosloskey

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

[Ariba Jones]

Jim,

Yes, the ; is a separator (component) in the message.  When Star sends out the HL7 message it uses colons and semicolons.  On the engine, those are changed to pipes and carets.  This was an example of the way the field looks coming from Star.

Thanks,

Ariba

[Jim Kosloskey]

Ariba,

OK – then CONCAT will do the trick.

Jim Kosloskey

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

[Author]

Replies