Help using HRL with VRL

[Alice Kazin]

My first time using HRLs.  VRL Global settings Field sep: | – Termination character is rn

I have a file with the following format.  There are rn characters between each line.  

D|xx|xx

V|xxxx|xx

PI|xxxxxx|xx

C|xxxx|xx

C|yyuuu|zz

Then the next group.

I defined 4 different VRLs.  I tried various combinations below – with and without “Repeat while”.  It doesn’t make any difference.

HRL consists of the following

VRL Demog

     Repeat while:  Demog.recordType_1

                           Value D

VRL Visit

     Repeat while:  Visit.recordType_1

                           Value V

VRL Insurance –

    Repeat while:  Insurance.recordType_1

                     Value PI

VRL Charge –

    Repeat while: Charge.recordType_1

                      Value C

My problem is that I am getting each line as a new message.  

Message 1 only has Demog record.

Message 2 only has Visit record…etc

How do I get the individual lines to be grouped together?

Topic

[Robert Kersemakers]

Hi Alice,

Your HRL looks okay, but I would only repeat the Charge segments: the other segments only appear once, so no repeat required.

It seems your problem is not in the HRL, but in the incoming messages. I guess the incoming messages are set as ‘NewLine terminated’. But as the segments are also terminated by a NewLine, every segment is seen as a separate message.

Two ways to correct this: choose a different Termination character for the segments. Or read the messages as ‘Single’ and then construct a tcl-proc to turn this into separate messages.

Zuyderland Medisch Centrum; Heerlen/Sittard; The Netherlands

[Alice Kazin]

I converted the message to a pseudo-HL7 message and that did the trick.

[Author]

Replies