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.

[MarqueeCrew · Accepted solution]

@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.

[MarqueeCrew]

My skills are steadily improving.  Keep trying.  Follow anything that @Ned posts... He suggests http://regexr.com/

[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