Wednesday, July 4, 2012

Regex Toolkit - Some Important Regular Expressions for Data Cleansing

Here are some replace regex expressions I found myself using over and over for data cleansing

Match starts with

Match ends with

Match last two words only

Match last word only

Match www pattern (e.g.

Match Case Insensitive

Multiple Spaces
\s+     (one or more space)
 \s{2,} (two or more spaces)

Match text in parenthesis(inclusive)


Match text containing period

No comments:

Post a Comment