ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Designer Discussions

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

Tokenize / Parse Cells Beginning with Numbers

7 - Meteor

I'm new to RegEx and am having trouble with the syntax.


I have a set of data which begins with 4 numbers.  Below is an example...


2017 Culture/Engagement Conference


I need to parse this information into two columns.


Column 1: 2017

Column 2: Culture/Engagement Conference


Although I'm aware there may be other ways to accomplish this, I want to build up a knowledge base for using RegEx and wish to use this tool for this purpose.


The format of the data after the 4 digit year is inconsequential and will vary. 


Using a expression of \d{4} does yield a new column with the year, but the second column is just blank.   Any variance of this creates a new column which doesn't parse the data.  How must I setup the expression so that the data is output the way I need it?


Here is an example of my current setup.







15 - Aurora
15 - Aurora

Hi @G_WOLAK I mocked up a workflow let me know what you think?



7 - Meteor

Thank you @JosephSerpis. Worked perfectly.


Whats is funny is I watched the academy videos on this topic, but couldn't recall exactly which one it was.