Find String

[xyz_1011]

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!

[marcus_sommer]

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

[nsm1234567]

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,')