Parsing with Regex and ( in data

Question

Hello All,

I'm back with another Regex issue.  This time I need to figure out how to parse data out from between ( & ).  Parentheses seem to be special characters in Regex parsing and I cannot for the life of me construct a statement that will allow for extraction of data within them.

Example data: words words words words (important data)

Could someone please lay some knowledge on this hapless newbie?

Cheers

jdunkerley79 · Accepted Answer

You need to escape out the (,) with a \. So using a REGEX tool in parse the regular expression is:

$(.*)$

The part between the brackets will be parsed into a new field.