P
PK
Help!
I have been running around in circles with this one...
I have a field which contans text and numbers. I need to extract the
number, removing the text completely. Here is the tricky part: there is a
variable number of text characters before and after the number (sometimes no
text after the number).
Example:
abc123def (i want 123)
abcdefg456 (I want 456)
a789 (I want 789)
PLEASE help! I am pulling my hair out!
I have been running around in circles with this one...
I have a field which contans text and numbers. I need to extract the
number, removing the text completely. Here is the tricky part: there is a
variable number of text characters before and after the number (sometimes no
text after the number).
Example:
abc123def (i want 123)
abcdefg456 (I want 456)
a789 (I want 789)
PLEASE help! I am pulling my hair out!