How to check if a specific field value is selected

[#1]

Hi,

I have a field, [Alphabet], with values [a,ab,abc,abcd,abcde,...].

I want to be able to tell if 'a' is selected. But my usual technique,

if(SubStringCount(Concat([Alphabet], ', '), 'a')>0, etc., etc.),

doesn't work because if 'abc' is selected while 'a' is not, SubStringCount will still return a value greater than 0.

Anyone have a solution for this dilemma?

Thanks and best regards,

Ryan

[tresesco]

Simply, [Alphabet]='a'   ?

[#3]

If there's multiple values selected for [Alphabet], though, this will not work; e.g., if 'a' and 'ab' are selected, [Alphabet]='a' returns false.

[SunilChauhan]

left([Alphabet],1)='a'

or

wildmatch([Alphabet],'a*')

hope this helps

[maxgro]

perhaps

=if(SubStringCount('@' & Concat([Alphabet], '@') & '@', '@a@')>0, 'a','not a')

[tresesco · Accepted solution]

Right, for that use:

=SubStringCount( Concat(DISTINCT Alphabet&'%'), 'a%')

[MK_QSL]

=IF(INDEX('|'&Concat(Alphabet,'|'),'|a|'), 'Yes','No')

[#8]

Many thanks.

[jerem1234]

You can also use:

=if(max(match(Alphabet, 'a')), ..., ...)

Hope this helps!