topic Find String in QlikView

Find String

xyz_1011 — Mon, 17 May 2021 10:27:30 GMT

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!

Re: Find String

marcus_sommer — Tue, 18 May 2021 13:05:01 GMT

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

Re: Find String

nsm1234567 — Tue, 18 May 2021 21:07:11 GMT

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