Race Code for VXU

[Ryan Curtin]

I have a source system sending an XML file with race code in a comma seperated field i.e.
<race>2076-8,2106-3</race>. I need to convert that to HL7 2.5.1 in PID.10 for VXU so the PID.10 needs to be repeating I can force that by sub-ing the comma (,) for a tilde (~) . Is there a way within the XLATE to extract each code and treat it as an individual element that I can then pass to a table lookup to extract the textual value of the race code and append it to the HL7… (Or would it all just be better to write a TCL script to do all of this for me, and what)

convert:

<race>2076-8,2106-3</race>
to
2076-8^Native Hawaiian or Other Pacific Islander^CDCREC~2106-3^White^CDCREC

 

Thanks in advance.

Topic