Re: Copy HL7 record/file into PostgreSQL Table

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/