Blanking an Active null

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

copy statement using @null as source value and the field you want nulled in the destination.

If the value of first occurrence of xlateOutTypes is null, I set it to “ch”

If {[lindex $xlateOutTypes 0] == “null”} {

  set xlateOutTypes

}

These answers will not always work.  The problem here is not the contents of the field but the field type.  A true Active Null field has a type of null.  To make it a real null you must change the type.  So you may have to do something like:

set xlateOutTypes