Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a whole list of website links which I want to aggregate in an other listbox. For example if have all kinds of links that contain the word control, using a if statement I want to put this in a listbox (I have 8 groups I want to put the words in), so my if statement looks like this:
if(cm_parentid = '*control*', 'Control', if(cm_parentid = '*performancemanagement*', 'Performance Management', etc. etc.
The problem is that it doesn't understand the * as a fuzzy search. How can I make this listbox using parts of the word?
Thanks!
Paul
Hi Paul,
You can use the wildmatch function like this:
if(WildMatch(cm_parentid, '*control*'), 'Control', if(WildMatch(cm_parentid, '*performancemanagement*'), 'Performance Management'))
Hope it helps.
Hi Paul,
You can use the wildmatch function like this:
if(WildMatch(cm_parentid, '*control*'), 'Control', if(WildMatch(cm_parentid, '*performancemanagement*'), 'Performance Management'))
Hope it helps.