|Applies To||RSA Product Set: NetWitness Logs & Network|
RSA Product/Service Type: Reporting Engine
RSA Version/Condition: 10.6.x, 11.x
|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.
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
$ file report.csv
report.csv: UTF-8 Unicode (with BOM) text
- 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.