Regex Question: how to extract text only from a text number mixed field?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Regex
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That is so funny!
- « Previous
-
- 1
- 2
- Next »