Text to Column - How to separate empty spaces?

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

Workflow

Accepted answers

DataNath

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

grazitti_sapna

@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!

All comments

DataNath

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

grazitti_sapna

@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!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335