Keith,
I’m assuming that when you state “blank out an active null” you want to make |””| into || is that correct? If so, then you can do this within an Xlate; you should be able to value a temp field with “” with a COPY statement:
COPY =”” —> @myactivenull
(The engine will then apply the backslash escape characters when you click the apply button, so you’ll see =””)
You can then just use an IF statement to compare if your input field is equal to @myactivenull and then copy @null when the condition is true:
IF 0(0).PV1.00053.[0] eq @myactivenull
COPY @null —> 0(0).PV1.00053.[0]
Hope this helps.
Jim Cobane
Henry Ford Health
