REGEX patern with underscore
Wasteb1n opened this issue · 0 comments
Wasteb1n commented
Great add-in, thanks. Found one issue so far. Using a pattern with escape "_" like _ gives #VALUE with IsRegexMatch. Haven't tried other functions. Changed to \x5F for now, then it works. Using the 64bit version in Excel365.
Full working pattern (can be written more compact, yes):
(&|#|:|;|=|%|(|)|\x5F|,|"|+|$|'|`|(.|-|/|\s){2,})