Like function in Current Selections

[#1]

Hi,

I'm looking for a way to check if a value 'X' is part of my selection.

for example if I select values​​: 1,2,3,4,5,6 my DATA field

I want to verify that the value '3 'is part of my selection

?

any idea?

[Roop]

Use:

FieldIndex('Data','X') and check that value returns is larger than zero

[MK_QSL]

Write below in Text Box

=IF(SubStringCount(Concat(YourFieldName, '|'), 'B'),'Yes','No')

If you select single or multiple values from your Field and if it contains B, you will get Yes otherwise No

[anbu1984 · Accepted solution]

GetCurrentSelections(DATA) like '*,3,*'

Or

Index(GetCurrentSelections(DATA),',3,')

[#5]

what about the negation ? Not Like doesnt work.

[anbu1984]

Not(GetCurrentSelections(DATA) like '*,3,*')