REGEX REPLACE removing all numbers in the beginning of a string

I want to remove all the numbers in front of the string in Column B, but stopping at the first letter. Im currently using REGEX_Replace([field 1], '^\d+\s*', '') , but its not exactly what i want. Be in mind i have a large data set im working with, so below are just some examples of my data.

Column A | Column B

A | 47477474 g-500 bucket

N | 4744 g500

Y | 4744 Lamar Heart

T | 05' Penny Stock

What I want

Column A | Column B

A | g-500 bucket

N | g500

Y | Lamar Heart

T | Penny Stock

Developer Tools

Regex

Accepted answers

IraWatt

Hey @fitch1892,

You can use this Regex to do this:

\w+ (.*)

Full explanation below.

Workflow.yxmd

Emmanuel_G

Hi @fitch1892 ,

Find a test attached with Regex_Replace just as you begin.

Let me know if it works as you want.

More details about Replace using regex : https://community.alteryx.com/t5/Base-de-Connaissance-Francais/Maitrise-de-l-outil-Regex/ta-p/321434

Cheers,

Test_Regex.yxmd

All comments

IraWatt

Hey @fitch1892,

You can use this Regex to do this:

\w+ (.*)

Full explanation below.

Workflow.yxmd

IraWatt

@fitch1892 To explain how my answer works

\w+

This will match with any word characters at the beginning of the text.

(.*)

This creates a group with all the other characters in the text.

I then replace the entire text with just what is in the group $1 (references the first group).

for more information on Regex check the Alteryx interactive videos found here: Interactive Lessons - Alteryx Community

Any questions or issues please ask
HTH!
Ira

Emmanuel_G

Hi @fitch1892 ,

Find a test attached with Regex_Replace just as you begin.

Let me know if it works as you want.

More details about Replace using regex : https://community.alteryx.com/t5/Base-de-Connaissance-Francais/Maitrise-de-l-outil-Regex/ta-p/321434

Cheers,

Test_Regex.yxmd

philipmannering

I think - without trying it - you could also do something as simple as,

TrimLeft([Field1], "0123456789' ")

Emmanuel_G

Very nice trick @PhilipMannering , I hadn't thought of that.🙂

akhuns

Hi, I'm new to REGEX and trying to get some practice in. How did you know that $1 references the group you want to replace here? I would think we would have wanted to use $2 if we want to replace with the second data group in the string, and remove the first. Thanks for your help!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703