extract numbers from text string
Posted on 2014-08-04
I have a table of data and one of the column contains a string. The first set of charachters are always a number. The second set of charachters are always letters. I am trying to extract the first set of numeric charachters. Using a simple left() function does not work becasue sometimes the numbers are one digit an sometimes they are two. For example, the string may look like the following:
In the example above, I need to extract the '11' and the '1' respectively.
Thanks for your assistance.