This video explains about how you can make use of nested REPLACE function to remove al the special characters from the phone column and further check the validity of the data using regular expressions. #SQL-PROGRAMMING
I have a dataset with special letters like: Ã, ã, É, é... And I want to replace than for the normal letter, for example: Ã, Â, Á, À, â, ã, à á for A. And do this with all the special letters. How can I do this using the regex?
