Xlate (.frl to hl7)

[Andre van Olden]

Scenario:  .flr (Field defined as Numerix 11bytes right justified)

The input file can have all zero’s or valid numbers (Telephone #).  In the Xlate, I need to format this number for the receiving system, but if “all zero’s”, null out the HL7 field.

When executing my “IF” statement ( tried > 0, gt 0, gt @null, > @null, > =0……and could go on and on ) the process will panic.

Tried using the testing tool to check the file against the .frl  –  in the lowest detail mode, the value displayed is “all zero’s”, but when expanding to more detail (mode 2 -4) the value displayed is null/nothing.

Other than defining this field from the input file as a string, why would this not work ?

Any suggestions that could shed light on this issue would be appreciated

Topic

[Vince Angulo]

If you want to not copy an all-zero phone number, I would try this:

IF frlTelephone ne =0000000

>>>COPY frlTelephone => hl7Telephone

Assuming 7-digits.

[John Mercogliano]

I’ve done something similar with numerics. My if condition looked something like:

   Field1.[0]    !=    @null

It works fine with ne also.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[Andre van Olden]

Thank you Vince and John for the input….

However, I guess the joke is on me.

Discovered the actual error to be occurring on the ELSE portion of my IF statement.  Where I was Null’ng out my field, I was using the PATHCOPY @null to outputfield (normally works great), but I guess this is not allowed in an .frl to hl7 Xlate even although it is not referencing infield to outfield.

I changed this to a regular COPY @null to outfield and it worked – no more panics

Thanks

Andre

[Author]

Replies