Remove a specific text pattern from string

Hey everyone.
I have a list of account names that I need to match with another one.

Some of the names in the list are names in the regular format NAME Middle_Name and Last_name
but some other have an ID in front, like:

#3193 Geroge Washington

or maybe

#3193-2 Geoge Washington

etc

So what I need exactly is a regex formula that when it finds this pattern (#4digit nr ) it removes it and leave everything else

Workflow

Accepted answers

Emil_Kos

Hi @soncoku,

My solution is even better now. I would even say that I like it 😄

Regex2.yxmd

All comments

Emil_Kos

Hi @soncoku,

I am relly basic with regex but it should work.

The output:

Regex.yxmd

neilgallen

if the strings only contain numbers and the "#" symbol on the front end, why not use the data cleanse tool set to remove numbers and punctuation? This would leave the name only.

soncoku

@Emil_Kos

This is pretty much it. but if it has #3110-2 Washington George I need the output to be 2 Washington George.

So it needs to remove #3110- and leave 2 Washington George

soncoku

@neilgallen

yes but some profiles have the 4 digit ID after the name and I don't want that removed

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703