Parse date time into new columns separated by a letter

[mzsweetumz]

Hi everyone,

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!

[Qiu]

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

[Qiu · Accepted solution]

@mzsweetumz 
In case you insist on RegEx 😁

[mzsweetumz]

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

[Qiu]

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

[Alteryx_AR]

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 :)