Parsing a date column into 2 columns

[theglamcoder]

Hi!

I am a bit stuck on splitting this into 2 columns:

Original: Feb 3, 2021 12:00:00 EST

Desired Output: Feb - 3 - 2021 in its own column and 12:00:00 EST in second column

I tried using text to column and reg expression but can't figure it out. I am new to Alteryx too

[Clifford_Coon]

Hi @theglamcoder ,

Use regex / parse:   (\w*\s\d*,\s\d{4})\s(.*)

regex101: build, test, and debug regex   is a good resource to test / learn regex.

 

[binu_acs]

@theglamcoder Another regex method

[ScottLewis]

A Formula version if you're worried about reading/maintaining the RegEx. 

[nagakavyasri]

Another approach: