not Null and not Blank

[alec1982]

hi all,

I have a column coming from a table with nothing on some rows.. I wasn't able to find out if the value is null, blank..or what is it.

I tried

if(len(trim(MyField))=0,1,0)

if(isnull(MyField)>0,1,0)

if(MyField=Null(),1,0)

if(MyField='' ,1,0)

if(MyField=' ' ,1,0)​

none of the above gave me 1 as a result when trying to switch the value on the script side..

the following worked when trying to test through the UI  if(MyField='' ,1,0) and returned 1 but i need it to work on the script..

Any idea on what is nothing could be?

Best,

Alec

[alec1982]

I did but it didn't work either.. I attached the qvw on the discussion on top

[alec1982 · Accepted solution]

I found the issue........... it is a concatenate of two tables on my script and I was trying with the top part while the issue on the second part of the concatenation..

[sunny_talwar]

Hahahahaha

Glad you found the issue.

Best,

Sunny