String Matching

[tuna]

Hi, is there any function that can find a string and return the match while also supporting the use of wildcards in the needle expression (essentially a vba equivalent of regex.match)? e.g. for such a function named StrMatch, StrMatch("Haystack", "s*") would return "stack"

Thanks

[Access_Blaster]

Hi Tuna,

Does it have to be a Function? A parameter query could display the same matches.

Example 1: Like [Example area code 1952] & "*" this would find all area codes that starts with 1952.

Example 2: Like "*" [Example area code 1952] & "*" this would find 1952 in any part of the string.


Richard