remove French chars from file

Tools & Utilities
Enthusiast

remove French chars from file

Hi Folks, I have received a client file which contains French characters I need to replace them with English characters. how can I do this using SQL.

example: extérieur Côté should be translated to:
exterieur Cote

any ideas are welcomed...
1 REPLY
Enthusiast

Re: remove French chars from file

Since you mentioned that the data is in the file, I think it would be more efficient to cleanse it before loading into the database, as the SQLs are quite cumbersome and time consuming for such purposes.

If you are client file is in unix, you can try the "tr" command ... it's what we used to do tricks with ...