Alteryx Designer Discussions

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

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!

robertcox_0-1608073094517.png

 

Alteryx Certified Partner
Alteryx Certified Partner

@robertcox ,

 

 the last word is your date:

 

getword([source],Countwords([source])-1)

 

 that's one way. 

cheers,

 

 mark

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!

 

christine_assaad_0-1608074060744.png

 

8 - Asteroid

Hi

@robertcox 

Try this

arundhuti726_1-1608083771092.png

 

 

 

5 - Atom

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

Labels