Export to Comma Delimited File ...

Question

Is it possible to change the separator when making a export ?

When we export all Cisco Hardware "Inventory - Physical Entities", we have a problem that there are "comma" in the export data

We tray to change the separator in "Regions Setting" with no look :-(

We like to use ; in steed.

bleearg13 · Answer

This is not a option as there are other , in my export data :-(

May be a stupid suggestion, but the exported data has quotes around the commas.  Couldn't you just find and replace the following string:

","

with:

";"

?

Haley · Answer

Thank you for the clarification.  The export to comma delimited file will always separate the fields by commas.  I will add a feature request to be able to export to a csv file where the separators are based off the Regional Settings List Seperator setting.

gstrand · Answer

we are using "comma delimited file" in Cirrus as in MS Excel

we made a exampel for you, see below or the attach file, you can see that the 6509 PSU have a , in the Description, then my billing system fails :-(

Node,"Machine Type","Physical Name",Description,"Serial Number",Model,NodeGroup,Country

CODKHUM1-1,"Cisco Catalyst 6509","PS 1 Absent High Power Usage Sensor","PS 1 Absent High Power Usage Sensor"," "," ",SR01,CP
CODKHUM1-1,"Cisco Catalyst 6509","PS 1 Fan Sensor","Power Supply Fan Sensor"," "," ",SR01,CP
CODKHUM1-1,"Cisco Catalyst 6509","PS 1 Input Sensor","Power Supply Input Sensor"," "," ",SR01,CP
CODKHUM1-1,"Cisco Catalyst 6509","PS 1 Output Sensor","Power Supply Output Sensor"," "," ",SR01,CP
CODKHUM1-1,"Cisco Catalyst 6509","PS 1 WS-CAC-3000W","AC power supply, 3000 watt 1",AZS09140GP1,WS-CAC-3000W,SR01,CP
CODKHUM1-1,"Cisco Catalyst 6509","PS 2 Fan Sensor","Power Supply Fan Sensor"," "," ",SR01,CP
CODKHUM1-1,"Cisco Catalyst 6509","PS 2 Input Sensor","Power Supply Input Sensor"," "," ",SR01,CP
CODKHUM1-1,"Cisco Catalyst 6509","PS 2 Output Sensor","Power Supply Output Sensor"," "," ",SR01,CP
CODKHUM1-1,"Cisco Catalyst 6509","PS 2 WS-CAC-3000W","AC power supply, 3000 watt 2",AZS0917085X,WS-CAC-3000W,SR01,CP

CiscoCatalyst6509.txt