"Dynamic" text to columns

[DavidOliverChapman]

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

[LordNeilLord · Accepted solution]

Hey @DavidOliverChapman 

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

[DavidOliverChapman]

@LordNeilLord 

Genius. Thanks mate.