Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hii all,
Please share some basic wildmatch example.
I tried to search but there nested data in other example i found.
Thanks
Please check
Match() is used for a case sensitive comparison. It matches the exact searchstring you pass in the function.
for Example: Match(Name,'Raja') , returns true if a person's name is exactly Raja (R caps).
WildMatch is used for a match where a string can be part of the search string.
For example :Match(Name,'Raja') will return true if a person's name is Raja, Maharaja, Rajan, or Rajat or some other string containing Raja in it.
MixMatch is same as Match but it is case insensitive.
PFA
I go through with help_wildmatch but i need some proper example which understand by easily.
Match() is used for a case sensitive comparison. It matches the exact searchstring you pass in the function.
for Example: Match(Name,'Raja') , returns true if a person's name is exactly Raja (R caps).
WildMatch is used for a match where a string can be part of the search string.
For example :Match(Name,'Raja') will return true if a person's name is Raja, Maharaja, Rajan, or Rajat or some other string containing Raja in it.
MixMatch is same as Match but it is case insensitive.
Ex : wildmatch (M, 'Veerendra*', 'katikala#', 'Middle name' )
returns 1 if M = Veerendra
returns 2 if M = katikala
return 3 if M = middle name
WildMatch Resturned the search string by using * and it is case insensitive,
ex;wildmatch(Month,'*h','f*','fe*'..,)
in this case its returns the search string of month field ended with ,'h',started with 'f'.
Thanks
venky
Hi Aniket,
You have been very active on the community but I find it hard to believe there is not one thread that you have received an answer to!
Can you take some time to mark correct / useful response's to your posts for the benefit of other people who may have a similar query?
Please check aniket_2701
Read the below thread please.