Extract Date/time from Text String

[qlikvw2019]

I am new to Alteryx,

I am a TEXT column with lots of data , i am looking to extract Date and Time from it. Regex might be the possible solution but not sure how. Please view the attached file for the input data.

Expected output:  10/31/2019 01:00:00 PM 

If no date/time is found then it should return null

The date/time has fixed format and is always mentioned after the "Scheduled Order Date(EST/EDT) : " 

Thankyou for your help.

[Greg_Murray · Accepted solution]

See attached.

[qlikvw2019]

It works great!

Can you please give some explain  the logic? Thanks

[Greg_Murray]

Hi there, 

Take a look at this link regexr solution

The section at the bottom of the page lays out exactly what's happening. You can also hover over the text and see why/how it matched.