Alteryx Designer Discussions

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

How would I extract the date from a a text string if the date format is not consistent?

5 - Atom

I have a set of 1,000+ records and they have a "Source" field that contains the record origin and date, but the date is not in a consistent format throughout the dataset.  I have tried using RegEx and Data Cleansing, but haven't been successful in extracting the date only from all of them.  Below is an exampele of what my fieldAny advice?  Thanks in advance!



Alteryx Certified Partner
Alteryx Certified Partner

@robertcox ,


 the last word is your date:




 that's one way. 




Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.

Hi @robertcox 


Please check the below and let me know if it works. It seems that no matter how many digits you have, it will always include "/". Cheers!




8 - Asteroid



Try this





5 - Atom

That is exactly what I am looking for!  Thanks for the advice!