What should I do when the log file that I have downloaded from HDE Secure Transfer is garbled?

For G Suite.

For Office 365.

Question:

What should I do when the log file that I have downloaded from HDE Secure Transfer is garbled?

Answer:

For the multilingual support, the Secure Transfer of log file (CSV format) is output with the character code [UTF-8].
When some problem occur, Excel has a garbled to open the CSV file with the character code [shift_JIS].
To open the log file without garbled, please follow the coping method. 

Open in Excel to convert the character code in the "Shift_JIS".

Save to convert the log file into character code [Shit-JIS] such as text editor. Then, open the file in Excel after conversion.

Explicitly open with the character code [UTF-8] in Excel.

1.Open the new Excel.
2.Click [Data] -> [Text file]. 

3.Select the log file and click [Import].

4.Change the following and click [Next].

Check [Delimited - Characters such as commas or tabs separate each field].
Select [Unicode(UTF-8)] in [File origin].

5.Change the following and click [Next].

Uncheck the [Tab] and check [Comma] in [Delimiters]

6.Click [Finish].

7.Click [OK]

This method is for Excel 2010, 2013 and 2016. It is possible that the method is deferent to depending on the version of Excel you use.

          
Was this article helpful?

Frequently Asked Questions (FAQs)

Powered by Zendesk