extract a number between parenthesis in a text field
Sorry for the newbie question. Can anyone help me extract a number between parenthesis in a text field that also contains other numbers?
ie: in a text field that contains "..67893TYUD(5894589)", I need the result to be "5894589". Not all the fields have the same number of characters, and the number inside the parenthsis can be from 1 to 9 characters.
Any Help Very Appreciated!