Checking for !null

[Scott Frye]

My data looks like this:

RXC|A|^^NDC|0

I want to do something if RXC2.1 is not null.  What would my if statement look like in  my Xlate?

I tried:

0(0).RXC.00314.[0]  ne @null

but it didn’t work.

Any ideas?

Scott

Topic

[Daniel Lee]

Try this:

0(0).RXC.00314.[0]  ne =

[David Caragay]

Just as an FYI, if your looking to check for an active null, you can check the field type.  Looking at the xlateInType value for the field in question will tell you if it is an active null.

Active Null looks like this….

XlateInTypes:>null< XlateInVals:>{}<     (|""|) Passive Null looks like this…   XlateInTypes:>ch< XlateInVals:>{}<      (||)

[Author]

Replies