Parsing Day, Date, and Time

[James89]

Hi everyone, 

I have a string that contains: Monday,March11,20248:55:10PM

Is there anyway that I can split them into 3 column into Day, Date, and Time respectively?

Thanks and regards.

[ShankerV · Accepted solution]

Hi @James89 

Please use Regex tool for your use case as below.

(\w+),(.+,\d\d\d\d)(.+)

 

Many thanks

Shanker V

[acotta17]

Hi @James89 

An alternative approach is to utilize the DateTime Tool, followed by a Formula Tool.