Re: Parsing HL7 records using Perl

2006-05-12 Thread Ryan Perry
A sample of an HL7 file: MSH|^~\&|REG|MCM|BTS||199601121005||ADT^A04|01|P|2.2 EVN|A04|199601121005||01||199601121000 PID|||191919^^^MYHOS^MR~123-45-6789^^^USSSA^SS|253763|SMITH^JOHN^Q|| 19560129|M|||123MAIN^^BUFFALO^NY^98052^""||(123)555-0100||S|M| 10199925^^^MYHOS^AN|123-45-6789 PD1|S|F|No

Re: Parsing HL7 records using Perl

2006-05-12 Thread Jay Savage
On 5/12/06, Kenneth B. Hill <[EMAIL PROTECTED]> wrote: I'm exploring ways to parse an HL7 record/file to a PostgreSQL database table. Actually, I think all I need to do is parse/transform the HL7 record/file to delimited flat-file, and then I can use PostgreSQL's copy command to load the data int

Parsing HL7 records using Perl

2006-05-12 Thread Kenneth B. Hill
I'm exploring ways to parse an HL7 record/file to a PostgreSQL database table. Actually, I think all I need to do is parse/transform the HL7 record/file to delimited flat-file, and then I can use PostgreSQL's copy command to load the data into a table. I would appreciate any guidance here.