(Oracle) Convert us7ascii in Snowflake?

Question

I'm looking for an alternative for the oracle convert() function in Snowflake. More specifically speaking I want to replace special characters in a string value (e.g. é, ä, ö) with the best matching letters.

In Oracle I can do something like this: convert('émíliõ', 'us7ascii') which would return 'emilio'.

I know I can write loads of replace() statements to do this but I was wondering if there is a better way to do this?

Answer 1

Try the TRANSLATE function Translate

Answer 2

Solved it like this:

translate('émíliõ',

'ÄäÀàÁáÂâÃãÅåǍǎĄąĂăÆæĀā
ÇçĆćĈĉČč
ĎđĐďð
ÈèÉéÊêËëĚěĘęĖėĒē
ĜĝĢģĞğ
Ĥĥ
ÌìÍíÎîÏïıĪīĮį
Ĵĵ
Ķķ
ĹĺĻļŁłĽľĿŀ
ÑñŃńŇňŅņ
ÖöÒòÓóÔôÕõŐőØøŒœ
ŔŕŘř
ẞߌśŜŝŞşŠšȘș
ŤťŢţÞþȚț
ÜüÙùÚúÛûŰűŨũŲųŮůŪū
Ŵŵ
ÝýŸÿŶŷ
ŹźŽžŻż',

'AaAaAaAaAaAaAaAaAaAaAa
CcCcCcCc
DdDdo
EeEeEeEeEeEeEeEe
GgGgGg
Hh
IiIiIiIilIiIi
JJ
Kk
LlLlLlLlLl
NnNnNnNn
OoOoOoOoOoOoOooo
RrRr
ssSsSsSsSsSs
TtTtÞbTt
UuUuUuUuUuUuUuUuUu
Ww
YyYyYy
ZzZzZz')```

Thanks @NickW !