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

[robertcox]

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!

[MarqueeCrew · Accepted solution]

@robertcox ,

 the last word is your date:

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

 that's one way. 

cheers,

 mark

[christine_assaad · Accepted solution]

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!

[Tyro_abc]

Hi

@robertcox 

Try this

[robertcox]

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

[ChiragPatel]

That's what I was look for as well. Thanks for sharing!