Blank values with expression?

[#1]

Hi,

I have straight table. I would need to show the values which have 'Instructions' with blanks

I used the below expression.

=If(Instruction='',Instruction)

will it gives the values only with blanks?

[MK_QSL]

May be

IF(ISNULL(Instruction), Instruction)

[srchilukoori]

a better way to identify the nulls and blanks is to use Len(Trim(<Field name>)) = 0

In your case:

=If(Len(Trim(Instruction)))=0', 'Instruction')

[#4]

Thanks. Just wrote it.

[agilos_mla]

if the ISNULL does not work, try this :

if(len(trim(Instruction))=0, Instruction)

[srchilukoori]

ISNULL() doesn't identify blank spaces.

[#7]

Thanks. it's not showing blanks . instead showing all. Any solution please.

Edit: will this works with table box?

[#8]

Thanks. This is not taking blank values. Any solution please

[MK_QSL]

As always, give us your sample data !

[agilos_mla]

Maybe it's a real white space: soft blanks (Chr(32)), hard blanks (Chr(160)), the tab character (Chr(09)) .

So try,  for soft blanks ,  if(len(trim(Instruction))=chr(32), Instruction)