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.
you could always export the csv and open text editor and do a find/replace for the ';".
This is not a option as there are other , in my export data :-(
My work around is export to excel and from there export to csv
There is "Customize Regional Options - List separator" working ;-)
Now Solarwinds Cirrus v3.5.1 just need to use normal Windows behaver !
Our current export options are as follows:
Can you please let me know which method you are using to export the Physical Entities report and provide a screenshot of the output of the export? This should help me to better understand your comma issue.
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,CPCODKHUM1-1,"Cisco Catalyst 6509","PS 1 Fan Sensor","Power Supply Fan Sensor"," "," ",SR01,CPCODKHUM1-1,"Cisco Catalyst 6509","PS 1 Input Sensor","Power Supply Input Sensor"," "," ",SR01,CPCODKHUM1-1,"Cisco Catalyst 6509","PS 1 Output Sensor","Power Supply Output Sensor"," "," ",SR01,CPCODKHUM1-1,"Cisco Catalyst 6509","PS 1 WS-CAC-3000W","AC power supply, 3000 watt 1",AZS09140GP1,WS-CAC-3000W,SR01,CPCODKHUM1-1,"Cisco Catalyst 6509","PS 2 Fan Sensor","Power Supply Fan Sensor"," "," ",SR01,CPCODKHUM1-1,"Cisco Catalyst 6509","PS 2 Input Sensor","Power Supply Input Sensor"," "," ",SR01,CPCODKHUM1-1,"Cisco Catalyst 6509","PS 2 Output Sensor","Power Supply Output Sensor"," "," ",SR01,CPCODKHUM1-1,"Cisco Catalyst 6509","PS 2 WS-CAC-3000W","AC power supply, 3000 watt 2",AZS0917085X,WS-CAC-3000W,SR01,CP
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: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:
";"
?