Help with Parsing using RegEx

[HongAlt]

Hello, thank you in advance for assisting.

What would be the expression to use with the RegEx function to generate the results shown in the picture (DateDay/DateMonthYear/Date Hour) attached from the data in the EmailDate Column,

I Attached the yxzp if that is needed. 

[christine_assaad · Accepted solution]

Hi @HongAlt 

This is an option:

(\w+),\s\d+\s(\w+\s\d+)\s(\d+):.*

Hope that helps. Cheers!

[HongAlt]

Thank You so much!

[ShankerV]

Hi @HongAlt 

One way of doing this is as below.

Regex can be used in any format to get the desired output. 

Expanding my expression for better understanding 

(\w*),\s\d{2}\s([[:alpha:]]*\s\d*)\s(\d*)

(\w*) - Anything in brackets will create a new column if we use the parse output method

\w reads a-zA-Z0-9

* read any number of characters until its matches the criteria

,\s\d{2}\s - this reads the remaining characters and it is not under the bracket those are skipped in the output

([[:alpha:]]*\s\d*) - Reads any letter and \s space and \d for digit

(\d*) - reads the hour

Many thanks

Shanker V