Pontifications

  • Following up from [yesterday’s Windows files are UTF-16 NOT UTF8, how to read them in ruby: ‘rb:bom utf-16’](http://rolandtanglao.com/2018/03/28/p1-windows-files-are-utf16-not-utf8-how-to-read-them-in-ruby/):
    • Google Play Store Review spreadsheets are in UTF-16 not UTF-8 for some strange reason.
    • Most tools like ruby expect UTF-8 and work better with UTF-8
    • Therefore convert to UTF-8 as follows using iconv:
      iconv -f UTF-16 -t UTF-8 utf16-spreadsheet-from-gplay-reviews.csv >utf8-spreadsheet-from-gplay-reviews.csv
    

Leave a comment on github