Replace Month Name with Number

Macro Library
1

IMO the best tool for this job is JavaScript, not RegEx.
I was pleasantly surprised to find that the month name need only be matched using the first 3 characters. So, I'm not sure what language you are using, but this seems to work for the two examples. I would expect JavaScript to use the local language as installed on your Mac.

See if this works for you.

Example Output

image

MACRO:   Get Month Number from Month Name [Example]

**Requires: KM 8.2.4+   macOS 10.11 (El Capitan)+**
(Macro was written & tested using KM 9.0+ on macOS 10.14.5 (Mojave))

#### DOWNLOAD Macro File:
<a class="attachment" href="/uploads/default/original/3X/0/5/053e1033dd8b162ee11af0a2b8900f61bc1fb44b.kmmacros">Get Month Number from Month Name [Example].kmmacros</a>
**Note: This Macro was uploaded in a DISABLED state. You must enable before it can be triggered.**


---


<img src="/uploads/default/original/3X/6/0/6080cfd13b14347553e8ce73876c546a6b495788.png" width="638" height="980">

### JXA Script

```javascript
(function (){
'use strict';

var kme = Application("Keyboard Maestro Engine");
var monthName = kme.getvariable("Month_Name") || "KM Var is missing/empty";

var monthIndex = new Date('1 ' + monthName + ' 2000').getMonth() + 1;

if (monthIndex) {
  return monthIndex.toString().padStart(2, '0');
}
else {
  throw new Error('[ERROR]  Invalid Month Name: ' + monthName); 
}

})();
```