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

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!

Regex

Parse

Date Time

Accepted answers

the last word is your date:

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

that's one way.

cheers,

mark

Christine_Assaad

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!

All comments

the last word is your date:

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

that's one way.

cheers,

mark

Christine_Assaad

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!

Hi

Try this

RegEx_date.yxmd

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

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

Quick Links

Unanswered
Community Events
Groups

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703