UDF8: RegExGet - return matches of regular expressions in excel (excel VBA)

Опубликовано: 16 Октябрь 2024
на канале: Matt Paul
16,125
69

https://github.com/MattPaul25/VBA_fun...

donate: https://www.paypal.com/cgi-bin/webscr...

I use the phrase "expression" to talk about the "pattern" of the regular expression. It's a misnomer. The actual code that we use to execute a regular expression is, in fact, a pattern.

I show you how to create a function that utilizes VBA's regular expression engine. You can utlitize this function for powerful text manipulation.

For more info go to this vba regEx tutorial: http://www.macrostash.com/2011/10/08/...

A very Similar function to mine-http://stackoverflow.com/questions/97...

More on the history of RegEx
http://en.wikipedia.org/wiki/Regular_...

Learning Reg Ex? Try this video:    • Best of Fluent 2012: /Reg(exp){2}lain...