Replace part of a Keyword Value

[Sheila_Shaver]

How can I replace PART of a keyword value?  I have a keyword "Description".  This is a free-form field for data to be entered with about 80,000 distinct values.  I have a list of words that my Admins would like to modify, but they are only parts of this keyword string.  Example would be "Shoemaker and Haaland" needs to be replaced with "Shoemaker & Haaland" --- but it is not the entire value of this keyword, so I can't do a keyword replace.  How can I do this data cleanup to replace part of my keyword value globally?

Thank you,

Sheila

[Sheila_Shaver]

Thank you for the quick responses.  For the Hyland employees - no worries, I DO NOT make any changes directly to the database.

I will see what I can do with the "Set Property to Expression" action in WorkFlow and will look into the Keyword Updater module.  I would like my Department Admins to be able to do this function.  I will post back when I have a solution.

Once again, thank you!

-Sheila