Is there any way to differentiate Null (Which represents absence of value) &

piyusha over 10 years ago

Is there any way to differentiate Null (Which represents absence of value) & Space ( Which is actual a value instead).

I have a requirement where in SAIL FORM's Textfield is Null First time but after putting value into it and then with Previous button concept in further Forms, update it with Space in First Form.

In an expression it is treating Null & Space as a same value....

Discussion posts and replies are publicly visible

0 Sathya Srinivasan
Appian Employee
over 10 years ago

Does isNull() not address your requirement?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 piyusha over 10 years ago

isNull is considering both Null & Space as same.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 nageswararaoa over 10 years ago

You can use lenb(sample_txt) function to check whether it is null or space.

The function will return the length in bytes of the text.
If it is null it will return 0(zero) otherwise it will return an integer more than zero.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 piyusha over 10 years ago

my requirement is different-: Here one text box is having value means >0 length. Now later on it is being deleted in text box. Now here I need to segregate Null & empty text box.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel