WildMatch

[#1]

Hi Community

Wondering if anyone can help, I am using an expression   = if(WildMatch(Function,'Group'),1,0)  in a variable that I am using to show/hide another object. 

"Function" is the value that is currently being used in a listbox, problem is that when I make other selections, e.g. 'Group' + 'Other', the resulting expression will be evaluated ad 0, as opposed to 1 if I select 'Group' alone! 

Is there a way of saying, if Group IS FOUND IN or CONTAINS, then 1,0?

Thanks Community

Peter

[sunny_talwar · Accepted solution]

Try this:

=If(SubStringCount(Concat(DISTINCT Function, '|'), 'Group') = 1, 1, 0)

[#3]

Wildmatch or Match only works in only one value in the field, So you can use substringcount or Only functions to get desired result.

[#4]

Thanks Sunny

I joined the two equations together, this worked well. Thanks for the tip though, will be very usefull for future projects.

if(WildMatch(GetCurrentSelections(Function),'*Group*'),1,0)

Thanks again Sunny

Peter 

[sunny_talwar]

No problem.

If you got what you were looking for, please close the thread down by selecting correct and helpful answers.

Best,

Sunny