RegEx Parse into 2 columns

[ritika27]

Hi,

I have a column in my data which looks like below:

Column A

I have to go

I need coffee

I am not feeling well

I should have not said that

He is good

His phone is ringing so loud for the past hour

I need to split it into 2 columns as follows:

Column A	Column B	Column C
I have to go	I have to	go
I need coffee	I need	coffee
I am not feeling well	I am not feeling	well
I should have not said that	I should have not said	that
He is good	He is	good
His phone is ringing so loud for the past hour	His phone is ringing so loud for the past	hour

Essentially, the last word from each record needs to be split into a new column. Can anyone please suggest? Thanks.

[ritika27]

Just realized it's much easier than I thought. I changed the format from datetime to date while importing. Problem solved!