negative-lookbehind - w3toppers.com

Lookbehind on regex for VBA?

VBA offers lookahead (both positive and negative) but rather inconsistently not lookbehind. The best example of using Regex with VBA that I have seen is this article by Patrick Matthews. [Updated example using Execute rather than Replace] While I am not completely clear on your usage you could use a function like this: It skips … Read more

Negative lookbehind equivalent in JavaScript

Since 2018, Lookbehind Assertions are part of the ECMAScript language specification. // positive lookbehind (?<=…) // negative lookbehind (?<!…) Answer pre-2018 As Javascript supports negative lookahead, one way to do it is: reverse the input string match with a reversed regex reverse and reformat the matches const reverse = s => s.split(”).reverse().join(”); const test = … Read more