-
Suggestion
-
Resolution: Unresolved
-
None
Issue Summary
The CSV file that is exported from the Managed Accounts of Organizations, this file is clearly separated by commas "," - but when the Display Name of users or some other column has a comma when trying to use Excel, Google Sheets, or any other spreadsheet application when organizing the Data into columns, a lot of data is broken, making it difficult for our Customers and our support to analyze it when we need it.
Steps to Reproduce
- Export Managed Accounts for a huge Org When some users have the Display Name with a comma.
- Text To Columns on Excel, and it will break the lines.
Expected Results
Perhaps generating the CSV file by enclosing each value of each field with quotation marks <" ">, or separating the columns with another character such as pipe < | > or semicolon < ; >
Workaround
There is no easy Workaround for this, our Customers have to analyze line by line, and for huge organizations, this is not possible.