Unanswered

CSV wrongly encoded

(0) Share

Report

Posted on by Baz

Hi,

I have a flow that downloads all the csv files located on an ftp server to a sharepoint online document library. It is based on 'Ftp list files', 'Ftp get file content' and 'SP create file'. Everything works fine, apart from the target files content encoding. All accented characters and LFCR end up wrongly encoded. Anyone having the same issue?

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Baz,

May I know how the characters and LFCR are shown in SharePoint? Please take some screenshots. Also try to create some new csv files to test if the issue is file-specific.

Regards,
Mona Li

Was this reply helpful? Yes No
Baz 4 on at

Like (0)

Report
Copy link

Link copied!

Hi MonaLi,

LFCR characters were initially shown as litteral \n\r (as if they had been escaped). Now the problem seems to be solved.
Regarding the accents issue, here is how a 'é' shows within the CSV file: 'ï¿½'.
It does this with various csv files, all in French though.

Thanks for your help.

Was this reply helpful? Yes No
hansmz 2 on at

Like (0)

Report
Copy link

Link copied!

Hi.
Did you find a solution to this problem? I have the same issue...

Brgds Hans-Martin

Was this reply helpful? Yes No
Baz 4 on at

Like (0)

Report
Copy link

Link copied!

Hi Hans-Martin,

Yes, it is solved for me now. By doing nothing but wait for this to be cleared.

Vincent

Was this reply helpful? Yes No