Parsing Text

[bar2]

I have a field that contains text, such as "Asia Pacific (Korea)" - and I want to pull just the word(s) within the parentheses out and populate it into another field - so I would in this case be pulling the letters Korea - how can I do this?

[comment]

Here's a generic formula to extract text between known prefix and suffix:

http://fmforums.com/forum/showpost.php?post/289685/