struggling a little on an iterate

[Lawrence Williams]

I am needing to translate an HL7 FT1.19 field to a database schema vrl.

I am wanting to transform this:

E10.9^DIABETES 1.5, MANAGED AS TYPE 1^I10~I50.9^CHF (NYHA CLASS II, ACC/AHA STAGE C)^I10~Q60.2^KIDNEY AGENESIS^I10

To this:

E10.9^DIABETES 1.5, MANAGED AS TYPE 1^~I50.9^CHF (NYHA CLASS II, ACC/AHA STAGE C)^~Q60.2^KIDNEY AGENESIS

…basically removing the ICD code set from the field.

Trying to accomplish this inside an xlt (to keep it simple for future maintenance)… so i built a field iterate and I feel I’m close, but I need to append each iteration to the previous….

Help me append them together here  🙂

Topic

[Jim Kosloskey]

I think you need to include the temp variable @HL7_DX in your CONCAT on the left side (make it first in the list). Also make sure you initialize the temp variable before the ITERATE (COPY @null –> @HL_DX).

So as you move along you will CONCAT the values TO the temp variable place the updated result in the temp variable.

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

[Lawrence Williams]

You are da man sir !!    Including my temp variable in the Source for the CONCAT worked like a charm.

[Jim Kosloskey]

I have to admit I forget that all the time .

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

[Author]

Replies