well i need your help.. i have run many simlations and saved their results in files.. no i need to "take" certain statistics frow that files and copy them into an excel document so as to make some graphs.. cn anyone help me write a script to do this automatically and not manually cause i have 350 files.. for example i want frow every file, the number in line 35 and the number in line 45.. is it possible??
** in line 35 for example, i have:
total misses : 3500000 and i want to extract the number into a certain cell of an excel document...
thanks in advance..
***i am working on linux..
PS: i don't know if i posted it in the right category..
help with script
-
- Sergeant
- Posts: 17
- Joined: Mon Apr 19, 2010 1:01 am
Re: help with script
If you are running this program on Windows, then you can use a language like VB.Net or C# to do this quiet easily. But since you are on Linux, I have no idea how to read/write Excel files without having libraries.
If you can run this program on Windows, then it can be easily found.
If you can run this program on Windows, then it can be easily found.
-
- Sergeant
- Posts: 17
- Joined: Mon Apr 19, 2010 1:01 am
Re: help with script
i am on linux.. is there any way of copying the statistics i need in columns so as to copy/paste them in excel... i think it can be done with awc script but i do not knwo awk script at all..
Re: help with script
me either. I worked out a similar job but that's on Windows long time ago. I'm sure doing this on Linux would be tricky.
awk seems to be a method but I can't tell you anything about it without knowing it.
awk seems to be a method but I can't tell you anything about it without knowing it.
-
- Sergeant
- Posts: 17
- Joined: Mon Apr 19, 2010 1:01 am
Re: help with script
can you help me to do this on windows? i will copy my files and do it on windows... thanks!Neo wrote:me either. I worked out a similar job but that's on Windows long time ago. I'm sure doing this on Linux would be tricky.
awk seems to be a method but I can't tell you anything about it without knowing it.
Re: help with script
Refer these two examples written in VB6.
Read a file line by line using VB6
Write data to Excel file using VB6
Everything you need is there. All you have to do is mix it up and make what you want.
Read a file line by line using VB6
Write data to Excel file using VB6
Everything you need is there. All you have to do is mix it up and make what you want.
Re: help with script
Hi,
You can write a shell script to output to a CSV (Coma Separated Value). Then you can easily process or even open with Excel and make it to column as u desired.
If u can give me a rough idea of your requirement, then i can help you.
You can write a shell script to output to a CSV (Coma Separated Value). Then you can easily process or even open with Excel and make it to column as u desired.
If u can give me a rough idea of your requirement, then i can help you.