I am trying to use isnull() and isblank() but they seem to always return false. Why?
Article ID: KB0088089
Updated On:
| Products | Versions |
|---|---|
| TIBCO MessageBroker | - |
| Not Applicable | - |
Description
Resolution:
- isblank() will return true if the string is null or has zero characters in it.
- If the string that you pass into isblank() has a space in it, for example " ", then isblank() will return false. In this case, you should use an istrim() before calling isblank() to remove blank spaces
- isnull(x) returns true when x is null.
If you are still having problems, please email your MB transform to support@tibco.com with a detailed description of the problem.
- isblank() will return true if the string is null or has zero characters in it.
- If the string that you pass into isblank() has a space in it, for example " ", then isblank() will return false. In this case, you should use an istrim() before calling isblank() to remove blank spaces
- isnull(x) returns true when x is null.
If you are still having problems, please email your MB transform to support@tibco.com with a detailed description of the problem.
Issue/Introduction
I am trying to use isnull() and isblank() but they seem to always return false. Why?
Environment
Product: TIBCO MessageBroker
Version: 4.1, 3.2.1.6
OS: All
--------------------
Feedback
Yes
No
Powered by
