I already have a partial answer to the problem here, which I understand as far as it is explained: How to most efficiently restructure a character string for fasttime in data.table
However, the task has been extended, and needs to deal with a variation of the orginal formatting.
I have a large dataset, with a column of dates of character class in the form of:
01 Jan 2014
dd MMM yyyy
Which I want to restructure to feed into
fastPOSIXct which only accepts character input in
The above linked question notes that an efficient approach would be to use regex and then supply the output to
fast.time. Here do I need to extend this to include a method to understand monthly abbreviations, convert to numeric, then rearrange? How would I do this? I know that there is a
month.abb as a built in constant. Should I be using this, or is there a smarter way?