how to automatically set csv file from UTF-8 to ANSI in windows?

Question

I am using an old app cannot handle UTF-8 characters. The csv files are SFTP to a folder with default UTF-8. Is there a way to automatically convert UTF-8 to ANSI? Can this be done in windows setting or I have to put some code to convert them?

Thank you!

Answer 1

Historically, I have used my own custom tools to do this.

But these days, if you have WSL, CygWin or MingW installed, you can use the GNU iconv tool to do the conversion, after first using other tools (such as head -c 3) to check if the input file has the 3 byte UTF-8 encoded BOM character as a file format marker.