SFTP connector and special characters in csv file

[Anonymous]

Hi!

I have encountered an issue when files are copied with the SFTP connector from a sharepoint site to a SFTP server with special characters in csv files. It seems this has started suddenly from somewhere around end of March 2019. At least one special character it changes is á to ï¿½ instead.

This same flow also moves the file from one place to another after the SFTP connector on the sharepoint site and the file is ok when that is done.

Here is the flow:

Thanks in advance for any help!

[v-lin-msft]

Hi @Anonymous,

Depending on what you type, it should be French, if your expected character is á, please type á instead.

This link is UTF-8 Encoding Debugging Chart as below:

https://www.i18nqa.com/debug/utf8-debug.html

If you still have problem, I advise you to do nothing but wait for this file to be cleared or to resubmit request to restart the flow.

I hope it can help you.

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-lin-msft ,

I can unfortunately not change what is coming out of the source system, it comes in the csv file as e.g. á or ø.

Why is the SFTP connector changing the character when it runs?

[v-lin-msft]

Hi @Anonymous,

Perhaps utf-8 does not support the conversion of French vowels in CSV file format. You may could to try other methods, such as changing connetor in other file format to store your data.

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.