Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Parse Date from String

cpet13
11 - Bolide

I have a column with strings, similar to the following - the_previous_week2024-01-18T20-39-19+00-00 and the_previous_week_2024-01-18T20-39-19+00-00. From both of these types of strings, I am trying to extract the date (2024-01-18). Can I use regex to do this, or is there another way I could do that? I am trying to do it in a way so that, if a different format of string is added such as the_previous_week_x2024-01-18T20-39-19+00-00, it will still work. Any thoughts on how I could do that?

2 REPLIES 2
MilindG
12 - Quasar
cpet13
11 - Bolide

That is great, thank you!

Labels
Top Solution Authors