HL7 Data type

[#1]

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,

[robert_mika]

What is your desired outcome?

[#3]

Hi Robert,

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

[robert_mika]

Is there any logic in this "madness"?

[jonathandienst]

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.)

[#6]

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

[ashfaq_haseeb]

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