Need help parsing this date

[xspunky]

2018-11-27T14:34:20.900Z

Does anyone know how I would parse this to 2018-11-27? And then the T14:34:20.900Z in another column? 

[Felipe_Ribeir0 · Accepted solution]

Hi @xspunky 

You can use this regex function

(.*)(T.*)

[xspunky]

Hey, thank you Felipe, I was able to solve it. Was there an article or something that you use to figure out the Regex Parsing? 

[Felipe_Ribeir0]

Hi @xspunky 

To be honest, i dont have any particular article to recommend. I watched a bunch of youtube videos (you can find a lot about this on youtube https://www.youtube.com/results?search_query=alteryx+regex) and after i learned the basics, i started practicing dynamically using this great site: https://regex101.com/

But you can find a bunch of articles about regex on the community, i did not read them to be honest but it seems like a good start:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Get-Started-with-Regular-Exp...

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/RegEx-Examples-12-Handy-Use-Cases/t...