HRL with repeating VRL

[Ruth Berge]

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.

Topic

[Ruth Berge]

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

[Jim Kosloskey]

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