Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Yes you can search for multiple search strings
If(Txt Like *SearchString1* And Txt like *SearchString1* ,'Contains both strings')
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
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)
Hi,
I have given general syntax, You can manipulate as per requirement.
Regards,