Start Free Trial

Alteryx Designer Desktop Discussions

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

"Dynamic" text to columns

DavidOliverChapman
7 - Meteor

Hi community

 

I have a dataset containing a rather tricky field. 

 

This is the Lease Terms for some commercial properties.

 

Happily, the team from which I receive this have set up their sheet with a single column "xx years from xx/xx/xx", rather than two columns "Length" and "Lease commencement date".

 

Not all cells contain a date, and there is no consistency in the string.

 

Any suggestions on how I could split this into two columns?

 

Best

 

DoC

 

clipboard_image_1.png

2 REPLIES 2
LordNeilLord
15 - Aurora

Hey @DavidOliverChapman 

 

You can use the regex tool (in Parse mode) using (.*)(\d{2}.\d{2}.\d{4})

 

Capture.PNG

DavidOliverChapman
7 - Meteor

@LordNeilLord 

 

Genius. Thanks mate.

Labels
Top Solution Authors