Skip to main content
Question

tester for blank values

  • December 3, 2014
  • 3 replies
  • 96 views

hi

 

 

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

3 replies

takashi
Evangelist
  • December 3, 2014
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

  • Author
  • December 3, 2014
Thanks Takashi

 

kept the right value blank and it worked !

 

 

simple things .....

 

 

thanks for your help

 

 

gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • December 4, 2014
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.

 

 

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings