Select in field blanks

[tinkerz1]

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

[alexandros17]

Yes, if you need to identify blanks then assign them a text

[sunilkumarqv]

you can try in different way

select in field

If(len(Field)=0 or Field='',Field)

[tinkerz1 · Accepted solution]

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.