+ Reply to Thread
Results 1 to 2 of 2

Thread: funny symbols when using reference tables - encoding of csv files

  1. #1

    funny symbols when using reference tables - encoding of csv files

    When using csv files containing special characters, such as special characters in other languages than English (e.g. ,, etc.), sometimes these characters are not displayed properly in Surveybe.

    This is due to the encoding of the csv file. What appears as text on the screen when creating a csv file is actually stored as numeric values in the text file (csv file). Your computer translates the numeric values into visible characters. It does this is by using an encoding standard that assigns each text character in a character set to a numeric value. A character set can include alphabetical characters, numbers, and other symbols. Different languages commonly consist of different sets of characters, so many different encoding standards exist to represent the character sets that are used in different languages.

    Surveybe uses the UTF-8 Standard. Csv files with special characters that are imported into Surveybe must be encoded in UTF-8 standard. Changing the encoding standard is simple in advanced text editors such as notepad++, which is freely available online.

    To change the encoding in notepad++, open the csv file in notepad++, select Encoding/Convert to UTF-8 from the menu options, save the csv file, and reimport the reference table.

  2. #2
    Thank you - this is very useful!
    Ann

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts