BusinessObjects Board

HL7 Message file extract

dataservices job design
#1

hi

I need to extract the data from HL7 message text file and put it into the separate columns in sql servers…

If anyone has any idea how to do the same… please share the steps…

see the file attached for sample hL7 message file.

regards
test.txt (0.0 KB)

leo_dec11 (BOB member since 2009-06-18)

#2

You should be able to get an extract specification from the powers that be to be able to isolate the records within showing delimiters / field names etc.

BarkyBaloo (BOB member since 2007-07-04)