Fields in the CSV files exported by Endpoint Encryption contain leading spaces
Last Updated May 16, 2019
Symantec Endpoint Encryption Manager allows reports to be exported to CSV file. For example, this report can be exported to a CSV file:
Symantec Endpoint Encryption Users and Computers
Symantec Endpoint Encryption Managed Computers
However, if you import the CSV file into a spreadsheet application such as Microsoft Excel you will find the following:
The data in each column apart from the first column contains a leading space.
The last column in the spreadsheet has no heading and each cell in the last column contains only a space.
The data in the last line of the CSV file may not be imported. Note that Excel does import the last line.
If the computer importing the CSV file has regional settings that are different to the computer that exported the CSV, columns containing a date may not display correctly.
Symantec Endpoint Encryption 11.0 and above.
The delimiter in the CSV file is a comma plus a space. This results in leading spaces when the CSV file is imported.
Each line of the CSV file ends in a comma plus a space. This results in a superflous last column.
The last line of the CSV file does not end with a carriage return.
The CSV file uses the date format of the computer that exported it.
Please do the following to workaround these issues:
Open the CSV file in a text editor and replace all occurrences of ", " with ",". In other words, replace comma plus a space with a comma. This will prevent leading spaces when you import the CSV file into a spreadsheeet application.
After importing the CSV file into a spreadsheeet application, delete the last column if every cell in that column contains only a space.
Open the CSV file in a text editor, navigate to the end of the last line of the file and enter a carriage return. This will ensure that the last line is imported.
Always import the CSV using a computer with the same regional settings as the computer that exported it. This will avoid any compatibility issues with the dates. Once you have saved the CSV in the native format of the spreadsheet application, you will be able to open the spreadsheet on a machine with different regional settings.
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe