tmehta.com Home
regexp/index.htm
  VB(A) functions
  Using functions
  Examples
  Patterns
 
Use this interactive page to ensure that you and VBScript are
in agreement about how it will handle your regular expressions
A text management tool that has been available on the Unix platform for a long time is known by the name 'regular expression' This powerful capability uses patterns to analyze strings.  These patterns are much more sophisticated than the wildcard capability available in most Microsoft Office programs including Excel.

Excel supports a limited wildcard capability -- search Excel help for the keyword 'wildcard' (without the quotes).

VBA supports a significantly better capability through its LIKE operator -- search Excel VBA help for the keyword 'wildcard' (without the quotes).

However, now that VBScript supports regular expression, it is possible to dramatically enhance the search and replace capability of both VBA and Excel.  The following are two wrapper functions that allow the use of regular expressions in Excel formulas!

Adding the necessary code to an Excel workbook

Using the functions

Examples of solving problems

For more examples see my posts here (also search for  regexp and author tusharm), as well as the Google archive of the Excel newsgroups.  There is also a lot of material on the web.  Search Google for more.

Understanding Patterns

 

beats by dre cheap canada goose canada goose outlet canada goose jordan retro 7 nike canada goose outlet nike legend blue 11s Michael Kors outlet coach factory jordan retro 7 nike Michael Kors outlet retro jordans air jordans nike jordan retro 7 beats by dre cheap nike louis vuitton outlet beats by dre cheap louis vuitton sac louis vuitton sac uggs coach outlet louis vuitton sac beats by dre cheap jordan retro 12 louis vuitton sac nike free run louis vuitton jordan retro 12 jordan 12 louis vuitton sac louis vuitton sac moncler jackets louis vuitton outlet louis vuitton outlet nike free run retro jordans retro jordans nike beats by dre cheap retro jordans Michael Kors outlet Michael Kors outlet legend blue 11s jordan retro 7 retro jordans Michael Kors outlet Michael Kors outlet beats by dre cheap canada goose outlet canada goose outlet jordan retro 7 beats by dre Michael Kors outlet jordan retro 7 beats by dre cheap nike air max coach outlet louis vuitton outlet louis vuitton outlet moncler jackets moncler jackets beats by dre cheap nike free run moncler jackets beats by dre cheap uggs outlet beats by dre cheap moncler jackets louis vuitton outlet louis vuitton outlet louis vuitton outlet louis vuitton sac beats by dre cheap nike air max jordan 12 canada goose nike jordan 7 jordan retro 7 coach factory nike Michael Kors outlet canada goose outlet legend blue 11s retro jordans nike Michael Kors outlet Michael Kors outlet Michael Kors outlet jordan retro 11 Michael Kors outlet jordan retro 7 jordan 7 Michael Kors outlet coach factory nike air max nike air max nike free run beats by dre cheap coach outlet nike air max uggs outlet beats by dre cheap moncler jackets moncler jackets uggs outlet nike air max jordan retro 12 uggs outlet beats by dre cheap jordan retro 12 moncler jackets coach outlet coach outlet nike air max retro jordans legend blue 11s jordan 7 retro jordans legend blue 11s jordan retro 7 nike canada goose outlet retro jordans canada goose outlet coach outlet air jordans canada goose beats by dre cheap coach outlet nike jordan 7 retro jordans air jordans legend blue 11s nike air max nike air max jordan retro 12 nike free run jordan retro 12 jordan retro 12 moncler jackets moncler jackets louis vuitton outlet nike free run jordan retro 12 moncler jackets louis vuitton sac moncler jackets coach outlet uggs louis vuitton outlet coach outlet moncler jackets uggs outlet canada goose outlet Michael Kors outlet coach outlet canada goose retro jordans canada goose outlet beats by dre cheap retro jordans retro jordans jordan retro 7 Michael Kors outlet canada goose outlet air jordans retro jordans jordan retro 7 Michael Kors outlet Michael Kors outlet legend blue 11s jordan retro 7 canada goose outlet louis vuitton sac beats by dre cheap nike air max sac louis vuitton jordan retro 12 moncler jackets moncler jackets moncler jackets moncler jackets nike free run coach outlet jordan retro 12 louis vuitton outlet beats by dre cheap beats by dre cheap jordan 12 moncler jackets moncler jackets jordan retro 12 louis vuitton outlet retro jordans jordan retro 7 nike jordan 7 beats by dre cheap Michael Kors outlet Michael Kors outlet jordan 7 coach factory Michael Kors outlet legend blue 11s canada goose outlet canada goose outlet legend blue 11s coach outlet canada goose outlet jordan retro 11 canada goose outlet nike Michael Kors outlet coach outlet nike air max louis vuitton sac uggs outlet louis vuitton sac louis vuitton outlet coach outlet louis vuitton outlet beats by dre cheap louis vuitton outlet nike air max uggs uggs outlet coach outlet beats by dre cheap jordan retro 12 jordan retro 12 coach outlet louis vuitton sac sac louis vuitton nike jordan retro 7 canada goose outlet jordan retro 7 Michael Kors outlet canada goose outlet canada goose outlet coach outlet retro jordans retro jordans Michael Kors outlet canada goose outlet coach outlet jordan retro 7 nike jordan retro 11 canada goose jordan 7 Michael Kors outlet coach factory louis vuitton sac uggs outlet beats by dre cheap nike air max nike air max nike air max beats by dre cheap louis vuitton outlet moncler jackets louis vuitton outlet jordan retro 12 louis vuitton outlet moncler jackets louis vuitton outlet nike air max louis vuitton outlet jordan retro 12 louis vuitton outlet uggs outlet coach outlet canada goose legend blue 11s Michael Kors outlet nike Michael Kors outlet legend blue 11s jordan retro 7 Michael Kors outlet jordan retro 7 jordan retro 7 retro jordans Michael Kors outlet Michael Kors outlet nike Michael Kors outlet coach outlet nike coach outlet beats by dre jordan 7 beats by dre cheap uggs uggs outlet louis vuitton sac beats by dre cheap louis vuitton outlet jordan retro 12 moncler jackets nike free run jordan retro 12 louis vuitton outlet louis vuitton outlet louis vuitton sac nike free run coach outlet uggs outlet coach outlet nike free run nike air max louis vuitton outlet Michael Kors outlet jordan retro 7 Michael Kors outlet Michael Kors outlet nike jordan 7 jordan 7 canada goose outlet Michael Kors outlet jordan 7 coach factory Michael Kors outlet legend blue 11s legend blue 11s canada goose outlet legend blue 11s coach outlet canada goose outlet jordan retro 11 canada goose outlet moncler jackets coach outlet coach outlet nike air max nike air max uggs outlet louis vuitton sac louis vuitton outlet jordan 12 louis vuitton outlet jordan retro 12 louis vuitton outlet uggs outlet uggs uggs outlet coach outlet beats by dre cheap jordan retro 12 jordan retro 12 uggs outlet retro jordans retro jordans coach outlet beats by dre cheap Michael Kors outlet Michael Kors outlet beats by dre cheap jordan retro 7 Michael Kors outlet Michael Kors outlet legend blue 11s legend blue 11s Michael Kors outlet coach outlet jordan retro 7 coach outlet Michael Kors outlet nike jordan retro 7 nike nike air max louis vuitton sac louis vuitton outlet beats by dre cheap nike air max coach outlet moncler jackets louis vuitton outlet nike air max nike air max coach outlet moncler jackets moncler jackets beats by dre cheap beats by dre cheap louis vuitton outlet louis vuitton outlet uggs outlet jordan retro 12 coach outlet jordan retro 11 uggs outlet jordan 11 legend blue michael kors outlet michael kors outlet Legend blue 11s french blue 7s jordan retro 11 jordan retro 11 louis vuitton outlet jordan 11 michael kors outlet jordan retro 11 jordan 11 Legend blue 11s jordan retro 4 oreo 4s oreo 4s michael kors outlet louis vuitton pas cher retro jordans michael kors outlet uggs outlet jordan 11 louis vuitton outlet louis vuitton outlet michael kors outlet jordan retro 7 jordan 11 legend blue jordan 11 jordan 11 michael kors outlet jordan retro 4 louis vuitton outlet louis vuitton outlet louis vuitton outlet jordan retro 7 legend blue 11s jordan 4 canada goose sale michael kors outlet jordan 4 jordan retro 11 Legend blue 11s jordan retro 11 louis vuitton outlet retro jordans jordan retro 11 jordan retro 4 jordan 4 michael kors outlet michael kors outlet jordan 11 jordan 11 michael kors outlet michael kors outlet jordan retro 11 legend blue 11s jordan 11 louis vuitton outlet michael kors outlet jordan retro 4 jordan retro 11 jordan retro 11 jordan 11 retro jordans louis vuitton outlet jordan 7 french blue french blue 7s jordan 11 jordan retro 4 jordan retro 7 jordan retro 11 jordan 4 michael kors outlet louis vuitton outlet air jordans legend blue 11s michael kors outlet legend blue 11s legend blue 11s louis vuitton outlet louis vuitton outlet jordan 11 jordan 4 jordan 11 jordan retro 11 jordan 11 jordan retro 11 jordan 11 jordan 11 legend blue louis vuitton outlet michael kors outlet jordan 11 louis vuitton outlet jordan 11 air jordan 4 jordan retro 11 jordan retro 11 louis vuitton outlet jordan retro 11 jordan retro 11 legend blue 11s michael kors outlet louis vuitton outlet canada goose outlet jordan retro 11 michael kors outlet michael kors outlet michael kors outlet michael kors outlet jordan 10 red cements french blue 7s air jordan 4 french blue 7s michael kors outlet jordan 4 louis vuitton outlet jordan retro 11 air jordan 4 jordan 11 michael kors outlet air jordan 4 louis vuitton air jordans jordan retro 11 air jordan 4 canada goose sale jordan retro 11 jordan 10 red cements jordan 4 jordan retro 11 michael kors outlet jordan retro 13 jordan retro 4 jordan 10 red cements jordan 11 jordan retro 4 jordan retro 11 jordan 4 jordan 7 french blue air jordans jordan 7 french blue air jordan 4 michael kors outlet jordan 11 legend blue louis vuitton outlet jordan retro 11 jordan retro 11 jordan 11 legend blue 11s michael kors outlet french blue 7s jordan 4 michael kors outlet jordan 11 canada goose outlet uggs outlet jordan retro 11 french blue 7s michael kors outlet jordan 7 french blue louis vuitton outlet jordan retro 11 jordan retro 4 jordan retro 11 louis vuitton outlet louis vuitton outlet jordan 11 jordan retro 11 canada goose sale jordan retro 11 jordan retro 4 jordan 4 louis vuitton jordan retro 11 oreo 4s jordan retro 4 air jordans jordan retro 11 michael kors outlet jordan retro 11 jordan retro 4 jordan 4 jordan 7 french blue french blue 7s jordan 11 michael kors outlet louis vuitton outlet air jordans jordan 4 michael kors outlet jordan retro 4 uggs outlet jordan 11 legend blue jordan retro 7 retro jordans jordan 11 legend blue michael kors outlet michael kors outlet air jordan 4 legend blue 11s michael kors outlet jordan 11 legend blue jordan 4 red cements 10s air jordans jordan 10 red cements jordan 11 michael kors outlet jordan retro 11 louis vuitton outlet michael kors outlet jordan 11 jordan 11 red cements 10s jordan 11 Legend blue 11s jordan 11 michael kors outlet canada goose sale jordan 11 legend blue jordan 11 jordan retro 11 air jordans michael kors outlet jordan 11 michael kors outlet louis vuitton outlet michael kors outlet uggs outlet louis vuitton outlet michael kors outlet michael kors outlet louis vuitton outlet michael kors outlet michael kors outlet legend blue 11s michael kors outlet louis vuitton outlet jordan retro 11 louis vuitton outlet jordan 11 michael kors outlet air jordan 4 air jordans louis vuitton outlet louis vuitton outlet louis vuitton outlet french blue 7s jordan 11 legend blue 11s michael kors outlet jordan 10 red cements jordan 4 jordan retro 11 jordan 10 red cements jordan retro 11 jordan 11 Legend blue 11s air jordans jordan retro 4 french blue 7s michael kors outlet air jordans jordan retro 11 uggs outlet red cements 10s air jordan 4 jordan retro 11 uggs on sale canada goose sale jordan 11 jordan retro 11 louis vuitton outlet jordan retro 11 jordan 4 jordan 11 jordan 11 legend blue jordan retro 11 jordan retro 4 michael kors outlet jordan retro 4 jordan 11 louis vuitton outlet jordan 4 canada goose michael kors outlet jordan 4 jordan retro 11 jordan 11 louis vuitton outlet jordan retro 4 jordan retro 4 louis vuitton outlet jordan 11 air jordans jordan retro 13 red cements 10s michael kors outlet air jordan 11 jordan 7 french blue french blue 7s oreo 4s french blue 7s michael kors outlet louis vuitton outlet jordan retro 11 michael kors outlet michael kors outlet oreo 4s air jordan 4 jordan 11 jordan retro 11 louis vuitton jordan retro 7 french blue 7s jordan 10 red cements french blue 7s jordan 11 jordan retro 11 michael kors outlet michael kors outlet jordan 11 jordan retro 11 jordan retro 4 louis vuitton outlet jordan retro 4 michael kors outlet oreo 4s jordan retro 11 louis vuitton outlet louis vuitton outlet jordan 4 jordan 11 jordan 4 louis vuitton outlet jordan 11 Legend blue 11s louis vuitton outlet michael kors outlet air jordan 4 louis vuitton outlet jordan 13 air jordans michael kors outlet jordan 4 canada goose outlet michael kors outlet michael kors outlet louis vuitton outlet jordan 11 jordan 4 jordan retro 4 jordan 4 oreo 4s jordan 7 french blue red cements 10s uggs outlet michael kors outlet air jordan 4 jordan 11 jordan 11 legend blue legend blue 11s jordan 11 jordan 11 jordan 4 louis vuitton outlet louis vuitton outlet louis vuitton outlet jordan 11 legend blue michael kors outlet air jordans michael kors outlet jordan 11 louis vuitton outlet oreo 4s jordan 4 jordan retro 4 air jordan 4 jordan 11 louis vuitton outlet legend blue 11s jordan retro 7 jordan 11 legend blue louis vuitton outlet uggs outlet michael kors outlet jordan retro 4 louis vuitton outlet michael kors outlet michael kors outlet michael kors outlet jordan retro 11 michael kors outlet jordan 11 jordan 7 french blue uggs on sale louis vuitton outlet uggs on sale