Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When I set up a button with an action for 'Select In Field' and try to find blanks in the search string by using (A|"")
QV will find A but not "", if I use just "", what QV really returns is all greyed out in the Multi box selection so I dont think its selecting blanks its just return nothing selected in that field.(I have other select in fileds triggering the selections)
What is the best way to set up and Or statement using select in field>search string? (A|"") is not the best way.
Should I find blanks in the load statement and put a text or symbol?
Thanks
Both answers are correct, Sunil's answer shows how you can adapt an expression to meet a search string.
Select in field
If(len(Field)=0 or Field="",'No String',Field)
Search string
('No String'|A|B)
This is clearer.
Yes, if you need to identify blanks then assign them a text
you can try in different way
select in field
If(len(Field)=0 or Field='',Field)
Both answers are correct, Sunil's answer shows how you can adapt an expression to meet a search string.
Select in field
If(len(Field)=0 or Field="",'No String',Field)
Search string
('No String'|A|B)
This is clearer.