AnsweredAssumed Answered

extract a number between parenthesis in a text field

Question asked by Larrydb321 on Apr 30, 2009
Latest reply on May 6, 2009 by KIDO

Title

extract a number between parenthesis in a text field

Post

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!

Larry

Outcomes