Would be useful if the IsMatch function had a baby brother that could extract/return a substring from a parent string by using a regex pattern. Either as a separate function or perhaps as an additional or optional output of the IsMatch function.
This is especially useful for strings that are variable where left/mid/right won't, but have predictable structure/patterns that regex can pick up.
Kind regards,
R
We added the Match and MatchAll functions last year that can extract substrings based on regular expressions.