Stripping out Text before a number, keeping the rest.

kconner

Hi,

I have been playing with Regex and Parse to no avail, can anyone help with the below...

I would like to strip out the beginning of an address leaving only the number and street address.

An example is the value 'C/O Southern Container 5687 East 89th Rd'.

I would like the result to be '5687 East 89th Rd' so I can Geocode the line.

Any ideas would be welcome.

Parse

Accepted answers

MarqueeCrew

@kconner,

Try this:

regex_replace([Field],"(.*?)(\d{1,}.*)",'$2')

It will remove all data before the 1st number(s).

Cheers,

Mark

All comments

MarqueeCrew

@kconner,

Try this:

regex_replace([Field],"(.*?)(\d{1,}.*)",'$2')

It will remove all data before the 1st number(s).

Cheers,

Mark

kconner

Thanks, worked like a charm.

I definitely need to learn more about Regex/Perl.

florayaoyao

Thanks Mark, this is extremely helpful to me as well, but one further step, I don't want to remove the negative sign if there is any before the numbers.

I have no idea about the story behind Regex. please help.

Thank you,

Flora

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703