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!
Solved! Go to Solution.
@mzsweetumz
Maybe we can just use the letter "T" as a delimeter.
@mzsweetumz
In case you insist on RegEx 😁
Thank you so much @Qiu , both of these work! Column to text is definitely simpler haha.
@mzsweetumz
Good to know it helps and thank you for accepting my answer. 😀
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 :)