Matching spaces in Xlate IF operation

[Troy Morton]

I’m trying to test if a field equals “RCC   ” in my Xlate.  That’s RCC followed by three spaces.  However, it doesn’t seem to be matching.  Is there a way I can match this field without TRIMing the spaces before the IF statement?

Thanks,

Topic

[Jim Kosloskey]

Troy,

Try COPYng the literal to a temp variable, then do the IF against the temp variable instead of the literal directly.

Let us know if that works.

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

[Troy Morton]

Confirmed the matching worked using:

COPY  

={RCC   }   ->   @LocationOncology

IF

0(0).PV1.00132.[0] ne =M && 0(0).PV1.00133.[0] ne =@LocationOncology

So, if you want to match something with spaces in an IF, you must copy the value to a variable first.

[Author]

Replies