To tick, where to find these tickboxes etc).
Trying to get a clean workflow through as few apps as possible, and I'm not going to perform edits ("replace all spaces with nothing") in a text-editor along the way, as it's just too hard to document exactly what needs to be done each time (i.e.
I imagine you're correct to say that Notepad or Wordpad is capable of producing UTF-8 from whatever sort of UTF Excel 2016 is creating when it creates a file described vaguely as "Unicode Text" in the dropdown menu of its "Save as." popup. Matter how I open it (with Excel or with Notepad).
Unfortunately, the csv file from my cloud-database (which runs an old version of Excel) doesn't have the full character-set of an extended-ASCII, so I get "Ren?e" rather than " Renée" no This char is not in the 7-bit ASCII codetable, it isĪn 0xe9 in ISO-8859-1 ASCII, it is a 0xc3 0xA9 in UTF-8, it is an 0xe9 0x00 in UTF-16LE, and it is an 0x00 0x00 0x00 0xe9 in UTF-16BE. Case 1 has an e-acute - this is an important case for me as it occurs in a few names in my database. I have appended some testdata (which is displaying correctly in my display, but of course YMMV). I have found a "Tool/Web Options/Encoding" menu in the "Save as" popup window of Excel 2016 Pro, but selecting UTF-8 in this dropdown doesn'tĪffect how the textfile is encoded - it still seems to be in UTF-16LE. Textfile" - I haven't found any documentation for this function of Excel, but by inspection it seems to be UTF-16LE.
but I can't figure out how to persuade Excel 2016 Pro to write a file using UTF-8 (so that my SPSS 25 can import it). xlsx, I can read it into my Excel 2016 Pro accurately. The 4th of May or is it the 5th of April?) Furthermore I try to avoid csv exports from Excel because of ambiguous dates such as 05/04/19. Anyway SPSS 25 uses some other variant of ASCII, perhaps UTF-7. For example, the e-acute is exported asĠxe9 in csv, but displays as a comma glyph in my Excel 2016 Pro when I open this csv. csv, it's encoded in some 7-bit ASCII (*possibly* ISO 8859-1) but I haven't figured out how to tweak my Excel 2016 Pro to import this particular codepage of ascii correctly as a csv. The database uses an old version of Excel. Hi, I'm trying to import data from a cloud-database to SPSS 25, so that I can analyse it.