Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
please check...
May be
IF(ISNULL(Instruction), Instruction)
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')
Thanks. Just wrote it.
if the ISNULL does not work, try this :
if(len(trim(Instruction))=0, Instruction)
ISNULL() doesn't identify blank spaces.
Thanks. it's not showing blanks . instead showing all. Any solution please.
Edit: will this works with table box?
Thanks. This is not taking blank values. Any solution please
As always, give us your sample data !
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)