topic string function in QlikView

string function

souadouert — Thu, 15 Jun 2017 23:47:34 GMT

hello,

want to check the existence of a string in another string, I used findof doent work

vkish16161 — Thu, 15 Jun 2017 23:51:15 GMT

Use wildmatch

for e.g. wildmatch('Dummy','*Dummy123*') returns 1

MarcoWedel — Fri, 16 Jun 2017 01:05:39 GMT

Actually "wildmatch('Dummy','*Dummy123*')" returns 0.

I guess you meant "wildmatch('Dummy123','*Dummy*')"

regards

Marco

MarcoWedel — Fri, 16 Jun 2017 01:07:09 GMT

Hi,

you could also use the Index() function

hope this helps

regards

Marco

souadouert — Sat, 17 Jun 2017 12:29:52 GMT

yes i used Index thank y

MarcoWedel — Sat, 17 Jun 2017 15:52:11 GMT

you're welcome

regards

Marco