Regular Expressions: An Unavoidable Technique

Posted: April 23, 2013 by Theodoulus in Excel, Others, VBA
Tags:

A Regular Expression provides grammar for a formal language; this specification can be interpreted by a regular expression processor, which is a program that either serves as a parser generator or examines text and identifies substrings that are members of the specified (again, formal) language. Regular expressions are used by many text editors, utilities, and programming languages to search and manipulate text based on patterns.

Regular expressions are used while validating an input by the user, searching a substring in a string (Partial Search) etc.
The most common thing that we all do in our daily life is (CTRL+F), i.e. FIND or CTRL+H means REPLACE in any editor or application on the computer.
Lets say, there is a list of blogs and one wants to extract all the blogs those are at wordpress then it can be achieved using a Regular Expression given below:

      regex=[a-z]+.wordpress.com

Above given regular expression can be used in any programming language that supports regular expression.

For more information please follow the link given below:

http://excelprogrammers.wordpress.com/2013/04/17/45/

Advertisements

Share your thoughts/feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s