Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Extract Date/time from Text String

qlikvw2019
7 - Meteor

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.

 

 

 

3 REPLIES 3
Greg_Murray
12 - Quasar

See attached.

qlikvw2019
7 - Meteor

It works great!

 

Can you please give some explain  the logic? Thanks

Greg_Murray
12 - Quasar

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.

 

Greg_Murray_1-1580225965935.png

Labels
Top Solution Authors