Due to some encoding problems, some characters in my database have been interpreted uncorrectly. Some chars have been replaced with the 'replacement character'. I need to find all such chars and replace them with space. I have been googling different solutions using sed, bash, perl, etc with no luck. Could someone share a solution how to find such characters (i.e. looking for this character in hex/octal value) and replace them with any other character?