Common Regular Expressions

Here are some common regular expressions I use with TextWrangler or EditPad to extract or modify data. They're listed by title, regular expression find string, and regular expression replace string. 

Use of these is unsupported (please don't ask me questions about them). For information and further reference, see www.regular-expressions.info.


CSV to Lines
[, ]+
\r

Lines to CSV
\r
,

Remove Whitespace
^([ \t]*)(.*)([ \t]*)$
\2

List to New Lines
, (\r*)
\r

Salesforce Log Filter (USER_DEBUG)
^[^\|]*\|[^U](.*)$\r

Clean Salesforce Log
[^|]*\|USER_DEBUG\|[^|]*\|DEBUG\|([^\r]*)\r
\1\r

Remove Punctuation
(\w+)[^a-zA-Z ]?
\1

Get Text Between Quotes
^([ \t]*["]*)([^"]*)(["]*[ \t+;]*)$
\2

Put Text Between Quotes
(.*)(\r|$)+
"\1" + \r

Remove Parenthesis
\(+.*\)+

Clean Salesforce Lines
^[^{]*{([^}]*)}(.*$)
\1

Get Salesforce Field from Log
^.*Name=([^,]*),(.*)$
\1

Get Left of Equals
^([^=]*)[ ]+=[ ]+(.*)$
\1

Get Right of Equals
^([^=]*)[ ]+=[ ]+(.*)$
\2
Comments