Hi, I need to extract text from a field mixed text with number, for example ABC123456 I need ABC
The problem is that length of text varies from record to record. For example:
ABC123456 (ABC is needed)
ABBC554466 (ABBC is needed)
ABBBB457888 (ABBBB is needed)
I think I could use Regex to parse it and I read some posts. When I try .*, it is not working.
Please help. Thank you!
Solved! Go to Solution.
Somewhere in the early 21st (shortly after I career changed into computers and programming) I faced a rather intractable problem, one that i figured out would require a rather complex regular expression, with something called a backreference. So I asked a friend and coworker, one I considered a very good programmer, if she could help me.
She asked me if i'd heard the one about the programmer and regular expressions.
"No," I replied.
A programmer says, "I've got a problem. Hey, I'll use a regular expression!"
"Hmm, now I have two problems."
And with that she turned around and walked away.
That is so funny!