prevent square brackets around data when exporting from List Widget

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

When exporting data from a list is there a way to prevent the square brackets around data in info columns?

Environment

DX UIM - All Versions
Dashboard Designer - List Widget

Resolution

This is expected in DX UIM’s Operator Console dashboards when working with “Info” type fields.

When you use the List widget and set the display column type to Info, the platform treats that field as a JSON-like object. During CSV export, Operator Console wraps the value in square brackets [] because it is treated as an array field, even if it contains only a single item.

This occurs because Info fields are designed to hold structured values, and the export engine serializes them as an array. Therefore, the brackets will always appear in the exported CSV.

This is working as designed.

As a workaround, you can use a simple script to remove the brackets after export. For example, on Linux:

sed -i 's/\["//g; s/"\]//g' exported.csv

This command will remove the [" at the start and "] at the end of the fields. You could achieve the same result in Excel, PowerShell, Python, or other scripting tools as needed.