Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Parse date time into new columns separated by a letter

mzsweetumz
8 - Asteroid

Hi everyone,

 

TiffanyLy27_0-1646264610989.png

 

I am trying to parse the date and time into it's own column. I tried using the RegEx but am having trouble coming up with the correct expression.

 

Ideally I just want the date, and do not care about the T or time.

 

Any help is appreciated!

 

5 REPLIES 5
Qiu
20 - Arcturus
20 - Arcturus

@mzsweetumz 
Maybe we can just use the letter "T" as a delimeter.

0303-TiffanyLy27.PNG

Qiu
20 - Arcturus
20 - Arcturus

@mzsweetumz 
In case you insist on RegEx 😁

0303-TiffanyLy27-1.PNG

mzsweetumz
8 - Asteroid

Thank you so much @Qiu , both of these work! Column to text is definitely simpler haha. 

Qiu
20 - Arcturus
20 - Arcturus

@mzsweetumz 
Good to know it helps and thank you for accepting my answer. 😀

Alteryx_AR
12 - Quasar

Hi @mzsweetumz 

 

You can use the regular expression (\d{4}-\d{2}-\d{2})T\d* in regex tool with parse or tokenize option.

Here is the solution. Hope this helps :)

 

ArtiRajput_0-1646268821763.png

 

ArtiRajput_1-1646268915372.png

 

 

Labels