im trying to set up a tester to pick up any blank streetname column .
ive tried 1. where string value is empty
2. value is "" (see attched screen shot)
but its not working . please avice
Question
tester for blank values
hi
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi,
I believe that the first method (leave "Right Value" blank) works well.
Check if the street name is really empty (see the value using the Logger).
Just be aware that a string consisting of whitespace(s) is not an empty string.
In addition, the "Attribute is Empty String" operator can also be used to test whether an attribute value is empty. "=" operator + blank right operand does not distinguish "empty", "null", and "missing". The "Attribute is Empty String" returns true only when the left operand is "empty".
Takashi
+15- Contributor
handy way is also to use [
LEFTVALUE: = [REGEXP {.+} {@ATTRIBUTE}] RIGHTVALUE: 0{.+} is a string with something i it
{.+} can also be used in stringsearcher &Co.