I knew I could do this with Data Cleanse, but I wanted to try out Regex for the first time ... and it was not nearly as complicated as I thought it was.
Wasn't aware of the 'Mon." format for the date parse tool, so had to resort to some manual manipulation. Also used data cleansing tool instead of regex.