i have a table in which a particular column contains both xml and hl7 reports, I want help in finding a way, how to extract the hl7 type data using sql and store them into another table,.
XML extraction is done.
An HL7 message is a hierarchical structure associated with a trigger event.