Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Stripping out Text before a number, keeping the rest.

kconner
6 - Meteoroid

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.

4 REPLIES 4
MarqueeCrew
20 - Arcturus
20 - Arcturus

@kconner,

 

Try this:

 

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

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

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
kconner
6 - Meteoroid

Thanks, worked like a charm.

I definitely need to learn more about Regex/Perl.

MarqueeCrew
20 - Arcturus
20 - Arcturus

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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
florayaoyao
8 - Asteroid

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

Numbers.JPG

Labels