Change a non uniform String Field to Date Format

[DataPirate26]

Hi all, 

Below I have shared a sample dataset in which the Hire Date field has dates which are written in various Forms and is not in Constant form. So I am unable to change it to the desired below given date format. 

I want to change this to given Date format ( dd-mon-yy) - 16-Sep-22 . Can someone help me with this ? 

[grazitti_sapna · Accepted solution]

@DataPirate26 , You can use regex for this. Please find my solution attached.

[DataPirate26]

@grazitti_sapna Thanx for you quick help. This worked Fine absolutely. 

[binu_acs · Accepted solution]

@DataPirate26 Another way of doing this with Contains function

[DataPirate26]

@binu_acs absolutely this also works fine.