Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Right, for that use:
=SubStringCount( Concat(DISTINCT Alphabet&'%'), 'a%')
Simply, [Alphabet]='a' ?
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.
left([Alphabet],1)='a'
or
wildmatch([Alphabet],'a*')
hope this helps
perhaps
=if(SubStringCount('@' & Concat([Alphabet], '@') & '@', '@a@')>0, 'a','not a')
Right, for that use:
=SubStringCount( Concat(DISTINCT Alphabet&'%'), 'a%')
=IF(INDEX('|'&Concat(Alphabet,'|'),'|a|'), 'Yes','No')
Many thanks.
You can also use:
=if(max(match(Alphabet, 'a')), ..., ...)
Hope this helps!