Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

You could try Wildmatch:

Flag:

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

Result:

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

View solution in original post

2 Replies
Not applicable
Author

You could try Wildmatch:

Flag:

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

Result:

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

Not applicable
Author

Exellent, Thank you very much that worked.

regards,

Roberto