Skip to main content
Sign Out

Welcome to Dell

My Account
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.
Sign In Create an Account Premier Sign In Partner Program Sign In
Contact Us

Your Dell.com Carts

Some article numbers may have changed. If this isn't what you're looking for, try searching all articles. Search articles

Article Number: 000022797

How to make Excel display multi-byte characters file name in InsightIQ CSV reports

Article Content

Instructions

Japanese or Chinese users of InisghtIQ 4.0.1 might not be able to correctly display file names with multi-byte characters in the CSV data usage report.

As shown below, multi-byte characters file name gets garbled in the InsightIQ CSV data usage report:
kA5j0000000TNr1CAG_1_0

 

This is because Excel does not process multi-bytes characters as UTF-8 format by default, hence not displaying these characters properly. InsightIQ can correctly output the characters in UTF-8 format if we open the .csv file with notepad or notepad+++. We can see the multi-byte characters are correctly displayed.

If the user would like to use Excel for data review, the CSV data file has to be saved as a text file first, and then imported into Excel. From Excel's import wizard, the user needs to indicate the format as delimited data and UTF-8 format. After that the outputs will show in UTF-8 format correctly.

kA5j0000000TNr1CAG_1_1

If the workaround above cannot address user's problem, please contact Isilon Support for further assistance.

Article Properties

Last Published Date

20 Nov 2020

Version

2

Article Type

How To

Back to Top