Showing results for 
Search instead for 
Did you mean: 

alteryx server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Reg Ex - Help with Parse on Field

Hi Alteryx Community!


I have a project I am trying to complete that involves parsing out sections of text from one field. For example I have the following data:


PROPERTY: 510291 - COUNTRY (FED) 4-8-9F

PROPERTY: 511243 - SAMPLE 3-15-2H


And the end result I want is one field for the numerical portion:





And then a second field for the name portion



SAMPLE 3-15-2H


Thoughts on the best syntax to use in RegEx? 


Thanks in advance!

I suggest:

PROPERTY: (\d+) - (.*)

The numeric bit will get in the first field and then the part after the dash will be in field 2.


Sample attached