This post is more than 5 years old
51 Posts
0
1845
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?
This post is more than 5 years old
51 Posts
0
1845
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?
Top
M_Salem
213 Posts
1
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
2.1K Posts
1
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
0
March 26th, 2014 03:00
Always welcome Fenglin
Fenglin1
2.1K Posts
0
March 26th, 2014 03:00
Good to know, Thanks Salem
pablosanzoni_bn
22 Posts
0
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