Blanking an Active null

[Keith McLeod]

I need to blank out an active null.  I have a request that if PV1:3 is an active null, then blank it out.  I would liike to do this within a translate.  Any ideas?

Topic

[James Cobane]

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

[Michael Lacriola]

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

[Keith McLeod]

I ended up establishing a proc that sets a flag if $xlateInTypes ==

[Alice Kazin]

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

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

  set xlateOutTypes

}

[Charlie Bursell]

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

[Author]

Replies