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

Parents

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

Reply

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

Children

No Data