topic HL7 Data type in Connectivity & Data Prep

HL7 Data type

Tue, 18 Aug 2015 18:43:15 GMT

Hi All,

Is there anyone try to read data from HL7?

Please see the data format below

============== 11.08 / 12:43:40 ==============

MSH|^~\&|MEDORA|GEHC|MedicaPlus|HealthInsights|20150811124340|Kasassbeh|ORM^O01|103220|P|2.3|||AL

PID|||373005||Flmban^Fawaz^^Abd Elhamid^^|-|19771129|M|??????^????^|||Unknown|00000|||||||||1007724154||||-|||Sau||1|

PV1|1|O||O|1149766|||4545|||||||WL||||1149766|||||||||||||||||||||||||20150811000000|||||||

ORC|SC|3157514|33306||CM||20150811124300|||||||||shahata|shahata||||||RAD|CT IN|6968

OBR|1|3157514|33306|CT0148|R||20150811124300|20150811124300|||CM|||||47843^^||||||20150811123252|||||^^^20150811124300^20150811124300||||Renal stone|&&||||20150811123252

Regards,

Re: HL7 Data type

robert_mika — Tue, 18 Aug 2015 23:10:09 GMT

What is your desired outcome?

Re: HL7 Data type

Wed, 19 Aug 2015 05:38:34 GMT

Hi Robert,

initially i ant to have it a structured row data in csv or text format

Re: HL7 Data type

robert_mika — Wed, 19 Aug 2015 05:52:39 GMT

Is there any logic in this "madness"?

Re: HL7 Data type

jonathandienst — Wed, 19 Aug 2015 06:24:24 GMT

Is this just a pipe-separated text file?

Have you got column names somewhere? (The first line presumably is not the column names because there are many blanks.)

Re: HL7 Data type

Wed, 19 Aug 2015 23:13:41 GMT

Hi Mohammed,

You should be able to import this but keeping in mind HL7 can have multiple delimiters e.g. |, ^ and & as well as carriage returns and there is a hierarchy to how these are applied with the pipe (|) being the primary delimiter then the others to identify sub components within fields.

What you will need to do is bring the data in once, separate on the pipe and then using either a resident load or QVD export perform each of the subsequent processing steps until you have broken everything down to the level you require.

Do you happen to know which HL7 schema is in use as this will determine which fields you have in your extract?

Hope this helps.

Rod

Re: HL7 Data type

ashfaq_haseeb — Sun, 23 Aug 2015 12:41:43 GMT

Hi,

You need to sit with HL7 expert and modify fields accordingly.

Have a look at sample application, I have tried to parse your message.

Hope it helps

Regards

ASHFAQ