Search with multiple wildcards

[cristian_av]

Hi

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

Name1 Name2 NameN ... LastName1 LastName2

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!!

[anbu1984]

Yes you can search for multiple search strings

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

[PrashantSangle]

Hi,

Try like this

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

Or

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

or

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

Regards

[anbu1984]

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)

[PrashantSangle]

Hi,

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

Regards,