How to remove extra space from date column?

[Isha_Gupta]

Hi

I have imported a text file in fixed width file format.

There are 3 columns of date. Right now they are in string data type.

Dates follow: mon dd YYYY format

Jul 13 2022 example

Now If the date is just single digit, there is extra space in between date and month...

Like: Aug  5 2021

How to remove this extra space if date is single digit. And convert this into date format so that no readability issues come with that space.

Thanks

[Martyn]

Use a Date Time tool with Custom configuration of..... Mon d yyyy

[FinnCharlton]

Hi @Isha_Gupta , using the DateTimeParse formula can put this into a date format (and data type) for you:

Hope this helps!

[Deano478 · Accepted solution]

Hey @Isha_Gupta just use a data cleansing tool like so: