Convert string to HL7
 

Hi,

I have a database with one column which contains a complete HL7 message as a string. I set up a database reader to retrieve this message and I need to sent this through HL7 LLP. So I need to convert this string (XML) to HL72.x. Can anyone push me in the right direction how to handle this?

<result>
<tber_bericht>MSH|^~\&amp;|TELEFORM|TELE|COV||2013 0823135054||QRY^A19|0265210011|P|2.4|QRD|201308231 35054|R|I|1|||1^RD|111111VDO001^123456789^^1911010 1^1234AB^136|APN|""|||</tber_bericht>
</result>

Regards

Casper

Assuming you have a transformer, your inbound data type is XML, and your outbound data type is HL7 v2.x:

However it looks like there's a problem with the actual data stored in your database. There's no carriage return between segments, so it'll be parsed as a single segment.

well, the cariage returns also exists as ascii character within the string but I removed them in the preprocessor :-) So now when I removed the code from my preprocessor and also use your transformer step it works!