Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Finding a word in a variable lenght string - help needed.

Hi,

I am trying to figure out a way in order to identify a specific word within a string. The string that is loaded is a variable lenght string and within that string it contains a country name. I am trying to script out some code to check if a specific country name exists. I have tried to play around with the functions but I am unable to make it work. Any ideas anyone?

Many thanks.

Roberto

1 Solution

Accepted Solutions
Not applicable

Finding a word in a variable lenght string - help needed.

You could try Wildmatch:

Flag:

If(Wildmatch(Field,'*Country*'),1,0) as Flag

Result:

If(Wildmatch(Field,'*Country*'),Field) as Result

2 Replies
Not applicable

Finding a word in a variable lenght string - help needed.

You could try Wildmatch:

Flag:

If(Wildmatch(Field,'*Country*'),1,0) as Flag

Result:

If(Wildmatch(Field,'*Country*'),Field) as Result

Not applicable

Finding a word in a variable lenght string - help needed.

Exellent, Thank you very much that worked.

regards,

Roberto

Community Browser