[anoukaimee]

I apologize in advance because I think this is a super simple question, but I've been searching for hours and, for the life of me, I cannot seem to figure it out.

I have many periodicals for which I'd like to standardize the date in the title. I already went through and "manually" changed the months from alpha to numeric (e.g., "Jan" to "01"). I now realize that I'd like to also have the year first, followed by the month.

So, for instance, I have a bunch of Gardeners' World Magazines, that are currently inputted as:

Gardeners' World Magazine, [MONTH] [4 DIGIT YEAR]
e.g., "Gardeners' World Magazine, 01 2011" (that is, Jan 2011)

I would like to format them as:

Gardeners' World Magazine, [4 DIGIT YEAR]/[MONTH]
e.g., "Gardeners' World Magazine, 2011/01"

BUT I can't figure d**n regex out (even though I find it totally fascinating), specifically how to replace a pattern. I figured out that "\d{2} \d{4}" expresses the date as it is now formatted, which is great, BUT I can't figure out how to transform it to the desired pattern. Please see pic for clarification.

Thanks!