Parse HL7 message

Question

Parse HL7 message

amns

SSCrazy

Points: 2628
More actions
March 9, 2011 at 6:10 am

#233698

I need to parse HL7 messages and import data to a SQL table. Since it's very complex, i'm trying to not recreate the wheel. Has anyone created a script or done this before?
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

FYI HL7 is a messaging specification for healthcare information systems.

I goggled a bit after this, and it appears that the parsing is not a trivial thing; one of the things i found was a project that has been worked on for over two years on sourceforge related to parsing this, so I doubt it's something trivial that can be done in a simple SQL statement.

that opensource project i found was in java, but i bet you could search around and find something int he language of your choice.

because of it's complexity, i think it would be parsed in a programming language, and the data inserted into SQL.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

amns SSCrazy Points: 2628 More actions · Answer 2

You are right, HL7 is complex.. I will try to parse messages in c# language.

Thanks

Jeff Moden SSC Guru Points: 1004405 More actions · Answer 3

amns (3/9/2011)
You are right, HL7 is complex.. I will try to parse messages in c# language.
Thanks

Why not just purchase a parser for it?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)