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.
Solved! Go to Solution.
It works great!
Can you please give some explain the logic? Thanks
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.