Text to Column - How to separate empty spaces?

[Joker_Hazard]

Morning everyone.

I am trying to separate empty spaces in a column, using Text to Columns tool with /s as delimiter. However nothing happens and I have no clue why is that.

2022-05-17 02:43:52
2022-05-17 02:43:52
2022-05-17 11:46:09

The data is like that. Anyone can help me out in this endeavor?

I want an output like this:

2022-05-17

11:46:09

Thanks

[DataNath · Accepted solution]

You’re using /s (forward slash). It should be \s (backslash)! 

[grazitti_sapna · Accepted solution]

@Joker_Hazard , another way to achieve that is to press space in the delimiter section. But \s or space will only work if your field is string datatype.

Thanks!

[grazitti_sapna]

@Joker_Hazard , the below method works for DateTime datatype as well. You can use the formula tool and use functions left and right to get the desired result.

I hope this helps!

Thanks!

[Joker_Hazard]

My gosh. I see I need more coffee and some rest. Thank you very much both of you!!

[grazitti_sapna]

@Joker_Hazard, I am glad we could be helpful 🙂

Thanks!