Free Trial

Alteryx Designer Desktop Discussions

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

Date Parsing help required

CiaranA
10 - Fireball

Can anyone put their mind to parsing this set of dates easily?

Ideally I would like a date format column, but where there isn't that level of information at the minimum a month.

 

Nov. 10
Sep.
Mar. 17-24
July 28-Aug. 5
March
Apr. 27
Oct.
Oct. 27-31
June 2
Aug. 8-12
June 9
Feb. 2019

1 REPLY 1
cplewis90
13 - Pulsar
13 - Pulsar

Hey @CiaranA,

 

See if this is what you are looking for. I started with a RegEx and then just separated everything out. Once you have this you should be able to create your dates in different ways using filters to set up different date time conversions.

regex dates.png

Labels
Top Solution Authors