I have some author names held in two different taxonomies where the terms are formatted in two different but overlapping ways. There are about 400 terms in each taxonomy, associated with roughly 700 posts. (The reason for all this mess is a complicated migration from an old version of Expression Engine.)
The first taxonomy is just default tags and, after the merge, I'll delete all these terms. The format is this, without the quotes, where "123" could be any three or four digit numeral:
" LastName, FirstName"
The other taxomomy, which I'll keep, is called author_tax. Its format is simpler:
Of course, I'd like to keep all the current post associations for both taxonomies. Best case scenarios is the terms are merged only if FirstName and LastName match. But even just matching LastName would save HOURS of manually merging. I might get some bad matches, but cleaning that up would be easier than a manual merge of 400 terms.
Is this possible or am I dreaming?
(By the way, these are not traditional WordPress authors who would create posts, but authors for a WP-driven magazine website. So none of this has anything to do with the user tables.)