Finally managed to get around to doing this - lol.
I just did a bulk metadata search and used the regular expression
and replaced with nothing.
This worked fine except for where there were special characters (' etc)
Not quite sure how the templates were supposed to work in the search.