文档介绍：正贝!|表达式专题(Regular expression feature)
I will relate to the party gradually given regular expression in the process of uNET platform, the two platform provides regular expression engine, together with the feeling is also very good. In the development of VBA, while Excel provides many built-in functions that help us to solve the problem of some string related treatment, but in some cases, use the built-in function or programming to solve, often feel powerless or very cumbersome, and use regular expressions to solve, but very simple. All of us here mainly to learn how to use regular expressions in VBA.
related tools
To do good work, must first sharpen his tools, which is what we need to pay attention to the use of regular expressions, we do anything, if good at using some useful auxiliary tool, can often achieve a multiplier effect. So when the use of regular expressions is the same, we need some tools to help us complete the task faster and better. I use regular expressions in a variety of auxiliary tools, through a comprehensive comparison and evaluation, eventually locking a weapon, as Guan Yu the hands of the "Green Dragon Saber" invincible.
This weapon is RegexBuddy,
Introduction to see www. regexbuddy, com, this is a sharing tool, there is no limit to the function, but only for 7 days, to money, need to register, but everyone in the Internet to find the regexbuddy 2. 3. 2 full version.
In addition, in August this year, for the latest version of has been I accidentally crack, want to give me a mail, ******@gmail. com mail note (Office club).
regular expression rules, character
ordinary character
Letters, digits, and underscores, and Chinese characters have no special definition behind the chapters of the punctuation is z/common character”. Ordinary character expression, when matching a string, match the same character.
For example 1: the expression "C”, "ABCDE" in the string matching, the matching results are matched to success: the content is: "C