Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Trap for #NULL! Value


Recommended Posts

I have tried just about every function to solve this same problem. ISBLANK, ISERROR, ISEMPTY, =#NULL

The only function that works for me is " ISNONTEXT" .

I use it in an IF statement

IF(ISNONTEXT(S8), PROPER(S9) & " " & PROPER(S10), S8)

If you find a better one let me konw.

Posted by Wendell D. on May 12 2009 5:53PM { U351 , C1464 }

Link to comment
Share on other sites

ISERROR is the best way. It will return TRUE if it is #NULL! and FALSE if its not. So it would look like

IF(ISERROR(S22), S1, S22& S23)

That will check is S22 is #NULL! and if it is, use S1. If its not, it will concatenate S22 and S23...

Posted by Brendan P. on May 12 2009 6:48PM { U40 , C1465 }

Link to comment
Share on other sites

  • 6 years later...
  • 4 months later...

Hi there,

I am having the same problem as Wendell D:

I have tried to catch if a source field = " #NULL!" , and I have tried using the ISERROR formula, and it is NOT catching the #NULL! value.

I am trying to catch if a source Date field doesn't contain a value, and to use a new Date if there is no value in the field, but whatever I try (all of the above suggestions) the software does not properly parse the #NULL! value... (I have even tried the ISDATE function - this doesn't work either)

Do you know if there is a bug with SCRIBE Insight version 7.9.0.5...

Posted by James H. on Sep 21 2015 8:56AM { U5150 , C12299 }

Link to comment
Share on other sites

  • 3 years later...

Important clarification, use IF(ISERROR(S##) as the first statement instead of the last.

This worked:

IF(ISERROR(S1), "Brown", IF(S1="W","White", IF(S1="G","Green","Blue")))

This did not worked:

IF(S1="W","White", IF(S1="G","Green",IF(ISERROR(S1), "Brown","Blue")))

Scribe seems to be unable to evaluate the value against alitteral value when it's looking at an error value.

Link to comment
Share on other sites

×
×
  • Create New...