Kenneth B. Hill wrote:
An HL7 file is a tagged file used to transfer electronic health records.
The file looks like:
MSH|^~\&|EPIC|EPICADT|SMS|SMSADT|199912271408|CHARRIS|ADT^A04|1817457|
EVN|A04|199912271408|||CHARRIS
PID||0493575^^^2^ID 1|454721||DOE^JOHN^^^^|DOE^JOHN^^^^|19480203|M|
NK1||CONROY^MARI^^^^|SPO||(216)731-4359||EC|||||||||||||||||||||||||||
PV1||O|168 ~219~C~PMA^^^^^^^^^||||277^ALLEN FADZL^BONNIE^^^^||||||||||
You *might* actually not have to parse this... just use | as your
delimiter with copy.
SIncerely,
Joshua D. Drake
You can download a PDF for details here:
http://www.hl7.org/Special/IG/final.pdf
-Ken
On May 12, 2006, at 10:01 AM, Scott Marlowe wrote:
On Fri, 2006-05-12 at 11:41, Kenneth B. Hill wrote:
I'm looking for a way to get an HL7 file into a table. My current
thinking is I need to parse the HL7 file to a flat-file and use the
copy command. I would appreciate some guidance on doing this. Thank you.
I'd love to help out.
Just one thing... What's an HL7 file?
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
