Does anyone know of an easy way to use regular expressions to replace special characters?
I'm trying to compare data from two tables to see where there are discrepancies, but a lot of them contain special characters. The business have said that if the character is the same without any accent, then that's OK by them - so if one system says "n" and the other says "ñ" then they want that to match.
So, I was hoping to do a regular expression replace on the text in both tables to replace "ñ" with "n" in both systems, and the same for a,e,i,o,u etc. etc.
Apart from going through a character map, does anyone know of a regular expression syntax that I can use to do the replacement?
I'm trying to compare data from two tables to see where there are discrepancies, but a lot of them contain special characters. The business have said that if the character is the same without any accent, then that's OK by them - so if one system says "n" and the other says "ñ" then they want that to match.
So, I was hoping to do a regular expression replace on the text in both tables to replace "ñ" with "n" in both systems, and the same for a,e,i,o,u etc. etc.
Apart from going through a character map, does anyone know of a regular expression syntax that I can use to do the replacement?
Comment