Regex Question: how to extract text only from a text number mixed field?

[marlline]

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!

[David-Carnes]

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.

[marlline]

That is so funny!