Clovertech

HRL with repeating VRL

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › HRL with repeating VRL

  • Creator
    Topic
  • September 29, 2011 at 12:21 am #52722
    Ruth Berge
    Participant

      I have an excel spreadsheet saved as a csv file.

      Can i use an HRL to remove the header rows and process each row as one HL7 message?

      I have been able to get a single VRL to write to HL7 but to do that I have to feed Cloverleaf one row at a time, stripped of headers.  I’d like to give Cloverleaf one csv file and have it parse out the messages.

    • Creator
      Topic
    Viewing 1 reply thread
    • Author
      Replies
      • August 13, 2015 at 5:23 pm #75284
        Ruth Berge
        Participant

          Lacking a response here (and granted this was 5 years ago now), I recall that we coded a java process to do this.

        • August 13, 2015 at 6:33 pm #75285
          Jim Kosloskey
          Participant

            Well the HRL answer is it depends.

            If the Headers and the detail (particularly the detail) have a column to identify it as a header or detail then this should be definable.

            If you don’t want the headers, then a small pre-process Tcl proc can remove them.

            Sorry I must have missed this in 2011.

            email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

        • Author
          Replies
        Viewing 1 reply thread
        • The forum ‘Cloverleaf’ is closed to new topics and replies.