Announcement Banner

lingtan

updated

13 years ago

L

lingtan

51 Posts

0

1951

March 25th, 2014 22:00

Can I have .csv output for symstat command?

I intend to run the following command:

symstat -type REQUEST -sid xxx -i 60 -c 120

Is there a way to specify the output to be in .csv format?

  • M_Salem

    213 Posts

    1420

    1

    Posted March 26th, 2014 02:00

    As Fenglin pointed out, The command you should use is as follows:

    1- symstat -type REQUEST -sid xxx -i 60 -c 120 -output xml_e >C:\output.xml

    2- Open Output.xml with MS Office Excel.

    3- Save As--> Other formats--> .CSV

    This should work fine. I tested it on Openoffice as well and it worked fine

    Hope it helps

    Mohammed Salem   @yankoora

  • Fenglin1

    6 Operator

    •

    2074 Posts

    1420

    1

    Posted March 25th, 2014 22:00

    No, I don't think so. But SE does support XML output with syntax -output xml_element following any SE command display. You can leverage it to make further data procedure.

  • M_Salem

    213 Posts

    1420

    0

    Posted March 26th, 2014 03:00

    Always welcome Fenglin

  • Fenglin1

    6 Operator

    •

    2074 Posts

    1420

    0

    Posted March 26th, 2014 03:00

    Good to know, Thanks Salem

  • 1420

    0

    Posted March 31st, 2014 11:00

    Hi Lingtan


    I have done a similar task you are needing right now. As a general rule almost every SE command can be pointed at the end like this, >filename.txt, which means that the output of the command will be recorded in a TXT file, you could also try to generate .CSV extension

    Regards