Exporting to CSV file shifts column content if there is a comma in the results

Products

• IT Management Suite

Issue/Introduction

The customer is generating reports from Manage > Computers.
He is adding a filter for active computers and primary user, asset status, etc. for example.

 
The report looks normal and acceptable in the console.

However, when he exports to a CSV file, the formatting is getting messed up, shifting values to the right.

Environment

ITMS 8.5 RU3 

Cause

Known issue. What seems to be causing the issue is the results from vAC_PrimaryUser: there is a comma between [last name], [first name].

 
When he adds this column into the report, it is causing issues with the other columns.

Most of the time, vAC_PrimaryUser is formatted [last name], [first name]. However, the CSV file puts the last name on one cell and first name on the next column, shifting everything to the right.
 
Also, when a "user" is missing in vAC_Primary, it shifts the other columns to the right and doesn't put a blank in the primary user cell.

Resolution

This issue has been reported to our Broadcom Development team.
 
A possible workaround is if you save the filter results "As a report" instead of "Export".
Then for the saved report, you can "Save As >Spreedsheet", the CSV formatting should stay fine.