First you need to fully understand the input data pattern. Is the number that you want to extract always in the same starting and ending position or it is quoted by brackets?
If the former, you can use mid() function as someone suggested, if later then you need to combine the search() function to locate the position of the open and end brackets.