Help with xlate, please!

[Tom Arrowsmith]

I am trying to write an xlate where if the PV1-3 is NOT equal to one of three different values – AND the PV1-2 is equal to E, then change the Message from an A08 to an A04.

I have experienced success if stipulating only one of the three values with this code:

0(0).PV1.00133.[0]   ne=ERL &&  0(0).PV1.00132  eq=E

then copy….(blah, blah)

that works….

…. It’s when I try to say (ne=ERL || ne ERP || ne=ERC) && eq=E that I run into trouble.

I want the A08 message to be translated to an A04 if the PV1-3 is equal to ERL or ERP or ERC – And the PV1-2 is equal to E

Help, anyone?

Thanks!

Tom Arrowsmith

(703) 779-5474

Topic

[Max Drown (Infor)]

Tom, try using a nested IF statement instead.

Code:

IF blah || blah || blah
 IF blah
   do it

-- Max Drown (Infor)

[Robert Milfajt]

It’s logic 101, if you have (ne ERL) OR (ne ERP), there is a conflict in that ERP does not equal ERL so the first part is true even though the second is false, so it will execute because of the OR.

You need to use AND:

if (ne ERL) and (ne ERP) and (ne ERC) will be true if PV1-3 is not equal to ERL, ERP and ERC, i.e., any other value.  Otherwise, if it is equal to one of the three values, one of the arguments evaluates to false and thus the whole expression is false.

Hope this helps,

Robert Milfajt
Northwestern Medicine
Chicago, IL

[Tom Arrowsmith]

I got it to work with the nested if by using the following:

IF ! (0(0).PV1.00133.[0]  eq=ERC ||  0(0).PV1.00133.[0]  eq=ERP || 0(0).PV1.00133.[0]  eq=ERL)

(nested) IF  0(0).PV1.00132 eq=E

            then do it……

Thank you both for your help!

Tom

[Author]

Replies