did you add that single ' at the end because it is part of the article? (English only speaker here

) ?
You might need to escape it (removes special meanings):
\'
As to removing anything from any field
Metadata edit Bulk mode (2 or more items selected before entering the MDE), Search and replace tab
backup your metadata.db, you goof, and a lot of data could go south.

Create a
practice library of a few COPIES, you can even SAVE the S&R while practicing. It will be available when you switch back to the main Library (assumes both have the same columns involved)