Announcement Banner

lingtan

updated

13 years ago

L

lingtan

51 Posts

0

2312

October 23rd, 2013 02:00

Can symcli command output in csv format?

Is there a way to specify csv format for symcli command output? It will help a lot when using these output to do Excel report.

  • cincystorage

    2 Intern

    •

    467 Posts

    1137

    0

    Posted October 23rd, 2013 13:00

    The answer is "sometimes".  Many symcli commands have a "-output" option which supports csv, standard,  and xml... But not all of them support csv... 

  • julianvan

    6 Posts

    1137

    0

    Posted October 23rd, 2013 05:00

    you can use shell scripts to print it in CSV format.

    Best Regards,

    Fan Jun

  • AranH1

    2163 Posts

    1137

    0

    Posted October 23rd, 2013 07:00

    When you send the output to a text file it will typically be in tab or space delimited format, and when you open a text file in that format in Excel you have the option to confirm/add/remove columns to the data.

    You could also use the -output xml option to send the output into an XML format which will open up nicely in Excel in a table format.