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!

Regex

Accepted answers

David-Carnes

@marlline

You need to establish the marked group inside parentheses: ([A-Z]+)

4_marlline.yxmd

MarqueeCrew

@marlline,

I'm a big RegEx fan. I'm glad to see that this is working for you, but for the record I would like to propose an alternative solution for those that may not embrace regular expressions quite as quickly as you did.

ReplaceChar([Field1], "0123456789", '')

If you use the ReplaceChar function above, you can replace all numeric values with nothing. I would compare that with another regular expression formula of:

REGEX_Replace([Field1], "[^A-Z]", '')

That expression will take all non-A to Z characters and replace them with nothing.

Alteryx gives you so many options.

Cheers,

Mark

All comments

jamielaird

[A-Z]+ should do the trick

marlline

Why I still see "No Marked Groups Found"? Please help. Thank you!!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703