Hi, Please see table below. I have data that comes in as the example 'OriginalData' column but would like to convert the datetime from the original to the "Desired" format and keep all other cells. I tried using the "DateTime" connector but had no luck. OriginalDataDesiredThu Aug 1 01:55:10 EDT 2019 :08/01/2019 1:55:10cell 1cell 1cell 2cell 2cell 3cell 3cell 4cell 4cell 5cell 5Thu Aug 1 03:55:08 EDT 2019 :08/01/2019 3:55:08cell 6cell 6cell 7cell 7cell 8cell 8cell 9cell 9cell 10cell 10 Appreciate any help.

Parse date and convert to proper dateTime

Hi,

Please see table below. I have data that comes in as the example 'OriginalData' column but would like to convert the datetime from the original to the "Desired" format and keep all other cells. I tried using the "DateTime" connector but had no luck.

OriginalData	Desired
Thu Aug 1 01:55:10 EDT 2019 :	08/01/2019 1:55:10
cell 1	cell 1
cell 2	cell 2
cell 3	cell 3
cell 4	cell 4
cell 5	cell 5
Thu Aug 1 03:55:08 EDT 2019 :	08/01/2019 3:55:08
cell 6	cell 6
cell 7	cell 7
cell 8	cell 8
cell 9	cell 9
cell 10	cell 10