separate the date field into multiple column

[Khaled_Eid]

hi

I am khaled and I am new to working with Alteryx

how I can split the date field like This

2006-04-01 00:00:00.000 +0200

into three columns

I tried The text to columns tool to separate it and I filled the delimiter with space but it doesn't work

[MilindG]

[davidskaife]

Hi @Khaled_Eid 

Use \s as your delimter and that should work for you

[Khaled_Eid]

I also try it but it don't work

[Khaled_Eid]

should i convert it's type to date?

[davidskaife]

Hi @Khaled_Eid 

Apologies i had the slash the wrong way round (have updated original post) - if you use \s it should work. Doesn't matter what the data type is.

[MilindG]

That shouldve worked. If its a date format, you can use regex as well '(.*)\s(.*)\s(.*)'

[Khaled_Eid]

i realy don't know why it does not work.

[Khaled_Eid]

 

[davidskaife]

Can you share a set of your data, even just the formatted date field?