Import CSV - Words with accentuation

The Archives Help Topics
1

Hello everybody.

When i imported a CSV file from Dataset and in this file have words with accentuation only part of the word is imported.

Example:

This is part of my CSV File;

file.png1366×705 83.1 KB

And so that is imported;

Sem Título-1.png1345×666 61 KB

This is a possible Bug?

Thanks.

2

It may well be a bug - can you please try two things:

  1. Add the " delimiter around your field names (common practice for fields with spaces in them)
  2. Provide an extract of the source CSV file so we can run a test?

Thanks!

3

Hi Dan.

Thanks for response.

I will do this test and give a feedback.

This is the link for download the file

https://www.wetransfer.com/downloads/d829bf006c62f080901bf3fe2cfc4f5f20151202135035/8ed912eab5d082d33f2a02c9ba2bb07d20151202135035/8a53ea

Thanks

4

Hi - when I opened the file it wasn’t encoded in UTF8, which means that the special characters in the file were not encoded correctly.

I opened the xls and re-saved to csv but made sure I selected UTF-8 as the encoding.

Everything imported as expected once i’d done this.