Article Number | 000029856 |
Applies To | RSA Product Set: NetWitness Logs & Network RSA Product/Service Type: Reporting Engine RSA Version/Condition: 10.6.x, 11.x Platform: CentOS
|
Issue | When viewing a NetWitness generated Report with non-ASCII characters in the CSV output (e.g Hebrew), it does not display correctly in Microsoft Excel.
| Detect languageAfrikaansAlbanianArabicArmenianAzerbaijaniBasqueBengaliBelarusianBulgarianCatalanChinese (Simp)Chinese (Trad)CroatianCzechDanishDutchEnglishEsperantoEstonianFilipinoFinnishFrenchGalicianGeorgianGermanGreekGujaratiHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKannadaKoreanLaoLatinLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTamilTeluguThaiTurkishUkrainianUrduVietnameseWelshYiddish | | AfrikaansAlbanianArabicArmenianAzerbaijaniBasqueBengaliBelarusianBulgarianCatalanChinese (Simp)Chinese (Trad)CroatianCzechDanishDutchEnglishEsperantoEstonianFilipinoFinnishFrenchGalicianGeorgianGermanGreekGujaratiHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKannadaKoreanLaoLatinLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTamilTeluguThaiTurkishUkrainianUrduVietnameseWelshYiddish | | | |
| | | |
Text-to-speech function is limited to 100 characters
|
Tasks | The NetWitness Reporting Engine produces a valid CSV file encoded in UTF-8 (without BOM) if the output data contains non-ASCII characters.
Although the Unicode Standard does not require or even recommend to use the byte order mark (BOM) in UTF-8 there is a common problem where Microsoft Excel opens CSV files as ASCII because it uses BOM to detect that the stream is encoded in UTF-8. |
Resolution | As a workaround you can either:
- Convert a file to UTF-8 with BOM using any available tool or a script (e.g. vi)
$ vi report.csv :set bomb :set fileencoding=utf-8 :wq
$ file report.csv report.csv: UTF-8 Unicode (with BOM) text
or
- Import a CSV file using the following Microsoft Excel steps:
- Open Microsoft Excel.
- Import the data using, Data > Get Data > From File > From Text/CSV
- Select the file type of "csv" and browse to your file.
- In the import wizard, change the File_Origin to "65001: Unicode (UTF-8)" (or choose the correct language character identifier).
- The Delimiter should be a comma.
- Select Load.
|