Removing diacriticts

Database
Highlighted
Enthusiast

Removing diacriticts

Hi,

 

Please, how to replace specific chars at one time?

I need to replace chars in line 1 for chars in line 2, in this order:

 

ÁÀÃÂÄÉÈÊËÍÌÎÏÓÒÕÔÖÚÙÛÜÇ
AAAAAEEEEIIIIOOOOOUUUUC

 

I'm looking for something like TRANSLATE function in SAS.

Or I need to make a command for each char?

Thanks! ;)


Accepted Solutions
Teradata Employee

Re: Removing diacriticts

Teradata has a translate function like Oracle's, called OTRANSLATE.  It would do this.  E.g.,

Select otranslate(<column-name>,'ÁÀÃÂÄÉÈÊËÍÌÎÏÓÒÕÔÖÚÙÛÜÇ','AAAAAEEEEIIIIOOOOOUUUUC');
See the SQL Functions manual, such as here, for details.

1 ACCEPTED SOLUTION
2 REPLIES
Teradata Employee

Re: Removing diacriticts

Teradata has a translate function like Oracle's, called OTRANSLATE.  It would do this.  E.g.,

Select otranslate(<column-name>,'ÁÀÃÂÄÉÈÊËÍÌÎÏÓÒÕÔÖÚÙÛÜÇ','AAAAAEEEEIIIIOOOOOUUUUC');
See the SQL Functions manual, such as here, for details.

Enthusiast

Re: Removing diacriticts

Thank you so much!