String Matching

[tuna]

VBA equivalent of regex match

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? e.g. for such a function named StrMatch, StrMatch("Haystack", "s*") would return "stack"

Thanks

 

[Brianwarnock]

You could use Instr to find where the first occurence of the string before the wild card started and a combination of that plus Len and Mid to extract the data.

Brian