Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
for a list of comma separated strings, like
cloud, sun, sunshine, road, roadster
what is the right way to identify a specific string like 'sun' (but ignore 'sunshine') or 'road' (but ignore 'roadster') in the UI
Thanks a lot in advance!
You may use something like: wildmatch(string, '*sun,*', '*road,*') to find the mentioned sub-strings. Depending on your use-case it might be also helpful to split the string into multiple rows within the script, for example with: subfield(string, ', ') as SubString.
- Marcus
Hi there,
As the other post mentions, I'd likely do this sort of work in the script, but depending on your use-case you could also do more hacky things like: =SubStringCount(Replace(Strings,' ',''),',sun,')