How to express if cell is not empty?

[jisephcirspy]

So I want to get the cells, which are not empty. I tried

=if(isnull(col),col)

but this is the completely opposite of what I want

I want it like

=if(!isnull(col),col)

[Chanty4u]

May be this?

If(Len(Trim(Col)) = 0, 1) AS EmptyCol

if(isnull(fieldName),fieldName)  as fieldName

or

if(fieldName=' ',fieldName)  as fieldName

or

if(len(fieldName)=0' ',fieldName)  as fieldName

[vinni]

Hi Jisephcirspy,

You can try below expression:

=If(ISNULL(Col),,Col)

[jisephcirspy]

no, this doesn't solve the problem 😞

[jisephcirspy]

it gives me an error...

[Chanty4u]

try this way

NULLASVALUE *; 

IF(IsNull(Col1), 'Not Available', ' ') as [Not Available];