I need to filter multivalue of strings by substring/character.
field coordinatorsID: a##1, b##2, c##3, d##3
field expertiseLevel can be one of "1", "2", "3" Exmple:
expertiseLevel = "3"
result -> c##3, d##3
What I tried:
attempt1:
| eval coordinatorsID_filtered = mvfilter(like(coordinatorsID,"%$expertiseLevel$")) error
attempt2:
| eval expertiseLevel = case(expertiseLevel == "1", "%1", expertiseLevel == "2", "%2", expertiseLevel == "3", "%3")
| eval coordinatorsID_filtered = mvfilter(like(coordinatorsID,$expertiseLevel$)) null
... View more