Parsing with Regex and ( in data

[TravisJWhite]

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 solution]

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.

[TravisJWhite]

Thank you so much - worked like a charm!

Cheers!