Extract Date from a String field (MMM DD, YYYY)

[aileenr]

Hello,

Is there a Regex formula I can use to extract a date from a long string field?

Example below:

[binuacs · Accepted solution]

@aileenr regex expression : (\w{3}\s\d+?\,\s\d{4})

[Alteryx_AR]

Hi @aileenr  Regular expression-  (\w{3}\s\d+\,\s\d{4})

2. Use DateTimeParse function 

3 . Simply use text to column tool with space as delimiter.