Does anyone know how I can remove this red dot from my data? It is causing issues, and not allowing me to replace text and cast to a date.

CodePudding user response：

First, find out what the unicode representation of that character is. You might have to use some string functions to locate that character if you don't have it handy. Once you have it, do

select unicode('the red dot character'); 

Then replace what that unicode represents as a character

select replace(col, char(that unicode number), '');

Sample implementation in case you have trouble locating the character

set str='r2_t1_date_c_2022_