topic Re: Search with multiple wildcards in QlikView

Search with multiple wildcards

cristian_av — Thu, 11 Sep 2014 02:45:47 GMT

I have ONE text field where the values it has are something like this:

Name1 Name2 NameN ... LastName1 LastName2

Name1 Name2 NameN ... LastName1 LastName2...

In one record, there could be multiple names/lastnames from the same person, but I can not split them because not all the persons has the same amount of lastnames or names...

How can I do a wildcard search that permit multiple words?

I want to do something like: *SearchString1* and *SearchString2*

Is it possible?

Or I have to split the text string into multiple fields? (Which is no totally useful, cause I don't know if the string i'm searching is in the first, second, or N position in the text..)

Thanks!!

Re: Search with multiple wildcards

anbu1984 — Thu, 11 Sep 2014 05:47:24 GMT

Yes you can search for multiple search strings

If(Txt Like *SearchString1* And Txt like *SearchString1* ,'Contains both strings')

Re: Search with multiple wildcards

PrashantSangle — Thu, 11 Sep 2014 05:55:35 GMT

Hi,

Try like this

If(wildmatch(filedname,'*SearchString1*SearchString2*'),fieldname)

If(wildmatch(filedname,'*SearchString1*','*SearchString2*'),fieldname)

If(wildmatch(filedname,'*SearchString1') and wildmatch(fieldname,'*SearchString2*'),fieldname)

Regards

Re: Search with multiple wildcards

anbu1984 — Thu, 11 Sep 2014 06:06:03 GMT

If both search strings are passed as one search string, then we should have second expr as below

If(wildmatch(filedname,'*SearchString1*SearchString2*','*SearchString2*SearchString1*'),fieldname)

Re: Search with multiple wildcards

PrashantSangle — Thu, 11 Sep 2014 06:20:31 GMT

Hi,

I have given general syntax, You can manipulate as per requirement.

Regards,