Help: char-delimited field to iterate in XLT

Jim, thank you very much for your response.

In fact, I must translate not only this repeating segment, but also other literal information (patient name, patient ID…)

How should I organize my input message format, in my XLT? A VRL with the literal information and a separated VRL for the report and a HRL with two fields: patient info and report?

How do i translate my message into a HRL?

Sorry do dig into this. I have never used HRL

Attached, my VRL and my CSV, generated via TCL from my text file. I replaced every line break with a n

Sincerely

Jim,

all the columns are textual information. The most important thing is that the “Report” is a repeating column, which does not have a fixed repeat number.

I changed the strategy now. I created two VRL: Patient info and Report. the report vrl has only one field, which is “report text”.

Now I created a HRL with both VRL. Patient is not repeating and report is.

Do you think this will work? How do I test a HRL? with a comma delimited file?

I made the report segment in my HRL as a fixed repeating segment (10), cause i don’t know how to create a condition (example, till it ends)

Yes, there is.

In fact, I was able to extract this info from a file and managed to map them into a HRL.

My main issue now is how do I declare the number of repetitions (its fixed with 50, but its variable, depending on the number of lines) and how do I iterate in the XLT

I managed to make It work.

Solution:

Input: HRL

Output: HL7 ORU

Iterate: Segment

Result from Testing Tool:

[0:TEST] The list of addresses are totally unresolvable

[0:TEST] [mid:0x31ea87c] unknown segment ” — ignored.

0(0).MSH(0)  :  >|^~&|CRIS|Radiology|PACS|Radiology|20140528122306||ORU|0019061702|P|2.3<

1(0).0(0).0(0).PID(0)  :  >|||0002192920||TEST VERS#O 14.04.02.01 (F)<

1(0).1(0).0(0).ORC(0)  :  >|||0019061702<

1(0).1(0).0(0).OBR(0)  :  >||0019061702|0019061702<

1(0).1(0).1(0).OBX(0)  :  >||ST|||

1(0).1(0).1(1).OBX(0)  :  >||ST||||||||||F<

1(0).1(0).1(2).OBX(0)  :  >||ST||||||||||F<

1(0).1(0).1(3).OBX(0)  :  >||ST|||asfget 5 554t t435 5 334 4 4345 4 t4 4 4 5 yw45 |||||||F<

1(0).1(0).1(4).OBX(0)  :  >||ST|||v 3434 3454  54|||||||F<

1(0).1(0).1(5).OBX(0)  :  >||ST|||5 56  |||||||F<

1(0).1(0).1(6).OBX(0)  :  >||ST|||56 |||||||F<

1(0).1(0).1(7).OBX(0)  :  >||ST|||y7j 67j |||||||F<

1(0).1(0).1(8).OBX(0)  :  >||ST||||||||||F<

1(0).1(0).1(9).OBX(0)  :  >||ST||||||||||F<

1(0).1(0).1(10).OBX(0)  :  >||ST||||||||||F<

1(0).1(0).1(11).OBX(0)  :  >||ST||||||||||F<

1(0).1(0).1(12).OBX(0)  :  >||ST||||||||||F<

1(0).1(0).1(13).OBX(0)  :  >||ST|||REPORT|||||||F<

1(0).1(0).1(14).OBX(0)  :  >||ST||||||||||F<

1(0).1(0).1(15).OBX(0)  :  >||ST||||||||||F<

[…]

Jim, thank you very much for your help!

The only think I need to do now is to make as many OBX segments as newlines in the file. this way, I’m always generating 50 OBX Segments. Can you help with this, please?

Guys, thanks for the replies

Jim, the main issue is that The patient_info don’t repeat for each line of my report. In one message, I have one patient info and multiple report lines, so I can’t make report lines repeat depending on my patient Info. I imagine that I must repeat using a repeatable field, right?

I inserted a dummy field with a default value, for each report line, and iterated comparing this field to this value.

Now the iterations worked fine

Best Regards