Data Protection Advisor DPA reports numeric values contain comma decimal separator. Unable to remove commas from decimal fields
Summary: Data Protection Advisor DPA reports numeric values contain comma decimal separator. Unable to remove commas from decimal fields. Where report is published with csv format to be imported into other software tool, having the commas in the number value is not desired. how can commas be removed from values for example for the columns in All Jobs report, Size and Size scanned. ...
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Instructions
For fields where by default a field has a Cast Value type of "Decimal" such as Size and Size Scanned as seen in the report preview, Format Columns.
1. Make a copy of the Backup All Jobs report.
2. Edit the report and in the last 'Set Value' operator, uncheck the Size Scanned field in the properties section.
3. Save the report and preview it. We need to do this to unset the original setting for the Size Scanned field.
4. Edit the report, in the same 'Set Value' operator, change the cast of the Size Scanned field in the properties section to 'Text' and check the box to show this field in the final report.
5. Save the report again.
6. In the Preview tab, go to Table Format > Series > Format Columns and you should see that the Size Scanned column is now set to 'Text'.
For fields where by default a field has a Cast Value type of Integer:
In Report Editor, go to Preview -> Table Template -> Series -> Format Columns -> Find the Field you would like to remove the comma, highlight "Cast" column, it will be in "Integer" type by default, change to "Text" or "Decimal" in drop down box, save the changes.
1. Make a copy of the Backup All Jobs report.
2. Edit the report and in the last 'Set Value' operator, uncheck the Size Scanned field in the properties section.
3. Save the report and preview it. We need to do this to unset the original setting for the Size Scanned field.
4. Edit the report, in the same 'Set Value' operator, change the cast of the Size Scanned field in the properties section to 'Text' and check the box to show this field in the final report.
5. Save the report again.
6. In the Preview tab, go to Table Format > Series > Format Columns and you should see that the Size Scanned column is now set to 'Text'.
For fields where by default a field has a Cast Value type of Integer:
In Report Editor, go to Preview -> Table Template -> Series -> Format Columns -> Find the Field you would like to remove the comma, highlight "Cast" column, it will be in "Integer" type by default, change to "Text" or "Decimal" in drop down box, save the changes.
Products
Data Protection AdvisorArticle Properties
Article Number: 000022523
Article Type: How To
Last Modified: 27 Oct 2022
Version: 5
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.