Parse everything before number?

Hello Life savers!!

I have a question. I have a column that has numbers and words and spaces. I want everything before numbers.

Following is how it looks like:

Wingate at Weston 75 Norumbega Road
E2 Franklin Square
The Blackstone 33 Blossom St
Woodsmallen shelter 794 Massachusetts Ave
Meacham St 4A
C Julius Rubin Court 6
RFD 1 BX 83 PODUNK RD

so I want everything before the number. for example "Wingate at Weston" form the first and so on.

Please help!!

Regex

Accepted answers

Thableaus

Hi @yaser

This should work

Use a Formula Tool

Trim(REGEX_Replace([Field], "(\D+)\b\d*.*", "$1"))

Cheers,

ephij

Regular Expression to the rescue! I prefer use in a formula tool

regex_replace([Field1],'^([\D]*)\d.*','$1')

All comments

Thableaus

Hi @yaser

This should work

Use a Formula Tool

Trim(REGEX_Replace([Field], "(\D+)\b\d*.*", "$1"))

Cheers,

ephij

Regular Expression to the rescue! I prefer use in a formula tool

regex_replace([Field1],'^([\D]*)\d.*','$1')

ephij

beat me, dang it.

yaser

NICEEEEE!!! Thanks ALotttt!

Could you please explain how you created it and the logic behind it? I got so confused :'(

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703