awk equivalent script Post: 302166183

Sponsored Content

Top Forums Shell Programming and Scripting awk equivalent script Post 302166183 by pondlife on Monday 11th of February 2008 07:50:23 AM

02-11-2008

Registered User

Ah yes, it might make things clearer Smilie

Here's the input:

Quote:

system-d-1-2008-02-10.xls : CPU Utilisation : Amber Alert : 8
system-d-1-2008-02-10.xls : I-O Statistics : Amber Alert : 11
system-d-1-2008-02-10.xls : I-O Statistics : Red Alert : 34
system-d-1-2008-02-10.xls : Network Statistics - bond0 : Amber Alert : 1
system-d-1-2008-02-10.xls : Network Statistics - bond1 : Amber Alert : 13
system-d-1-2008-02-10.xls : Network Statistics - eth1 : Amber Alert : 13
system-d-1-2008-02-10.xls : Network Statistics - lo : Amber Alert : 4
system-d-1-2008-02-10.xls : Process Run Queue : Amber Alert : 13
system-d-2-2008-02-10.xls : I-O Statistics : Amber Alert : 1
system-d-2-2008-02-10.xls : I-O Statistics : Red Alert : 1
system-d-2-2008-02-10.xls : Network Statistics - bond0 : Amber Alert : 1
system-d-2-2008-02-10.xls : Network Statistics - bond1 : Amber Alert : 6
system-d-2-2008-02-10.xls : Network Statistics - eth0 : Amber Alert : 1
system-d-2-2008-02-10.xls : Network Statistics - eth1 : Amber Alert : 6
system-d-2-2008-02-10.xls : Process Run Queue : Amber Alert : 3
system-d-3-2008-02-10.xls : CPU Utilisation : Amber Alert : 15
system-d-3-2008-02-10.xls : I-O Statistics : Amber Alert : 5
system-d-3-2008-02-10.xls : I-O Statistics : Red Alert : 30
system-w-5-2008-02-10.xls : Network Statistics - bond0 : Amber Alert : 2
system-w-5-2008-02-10.xls : Network Statistics - eth0 : Amber Alert : 2
system-w-8-2008-02-10.xls : Network Statistics - bond0 : Amber Alert : 1
system-w-8-2008-02-10.xls : Network Statistics - eth0 : Amber Alert : 1

And here's what I'm trying to achieve:

Quote:

system-d-1-2008-02-10.xls : CPU Utilisation : Amber Alert : 8
system-d-1-2008-02-10.xls : I-O Statistics : Amber Alert : 11
system-d-1-2008-02-10.xls : I-O Statistics : Red Alert : 34
system-d-1-2008-02-10.xls : Network Statistics - bond0 : Amber Alert : 1
system-d-1-2008-02-10.xls : Network Statistics - bond1 : Amber Alert : 13
system-d-1-2008-02-10.xls : Network Statistics - eth1 : Amber Alert : 13
system-d-1-2008-02-10.xls : Network Statistics - lo : Amber Alert : 4
system-d-1-2008-02-10.xls : Process Run Queue : Amber Alert : 13

system-d-2-2008-02-10.xls : I-O Statistics : Amber Alert : 1
system-d-2-2008-02-10.xls : I-O Statistics : Red Alert : 1
system-d-2-2008-02-10.xls : Network Statistics - bond0 : Amber Alert : 1
system-d-2-2008-02-10.xls : Network Statistics - bond1 : Amber Alert : 6
system-d-2-2008-02-10.xls : Network Statistics - eth0 : Amber Alert : 1
system-d-2-2008-02-10.xls : Network Statistics - eth1 : Amber Alert : 6
system-d-2-2008-02-10.xls : Process Run Queue : Amber Alert : 3

system-d-3-2008-02-10.xls : CPU Utilisation : Amber Alert : 15
system-d-3-2008-02-10.xls : I-O Statistics : Amber Alert : 5
system-d-3-2008-02-10.xls : I-O Statistics : Red Alert : 30

system-w-5-2008-02-10.xls : Network Statistics - bond0 : Amber Alert : 2
system-w-5-2008-02-10.xls : Network Statistics - eth0 : Amber Alert : 2

system-w-8-2008-02-10.xls : Network Statistics - bond0 : Amber Alert : 1
system-w-8-2008-02-10.xls : Network Statistics - eth0 : Amber Alert : 1

Many thanks,

p.

pondlife

View Public Profile for pondlife

Find all posts by pondlife

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

shell script equivalent for tcl function

Hello, I need experts help in converting the below tcl function to korn shell function equivalent. proc lsNetMaskToBits {mask} { set dw ; # Top N bits set set dw 0x ; # Make sure it's hexadecimal, else XOR fails. puts "lsNetMaskToBits dw $dw" set dw ; # Complement => low 32-N bits...

2. Linux

Need SCP script equivalent to FTP script .

Hi, Currently i'm using the folllowing FTP acript and its working. echo "open $server" > ftp_file echo "user $user $password" >> ftp_file echo "cd $remote_dir" >> ftp_file echo "lcd $local_dir" >> ftp_file echo "put $file">> ftp_file echo "bye" >> ftp_file ftp -nv < ftp_file I've...

3. Shell Programming and Scripting

Bash Script equivalent KSH script?

I always find BASH easier than ksh. At my home, i have written this bash script. I am finding it hard to write its equivalent in ksh, any suggestions? ###################################### #return seconds since `00:00:00 1970-01-01 UTC' (a GNU extension)...

4. Windows & DOS: Issues & Discussions

awk to findstr equivalent

Hi, I 'd like to translate this command from awk to findstr on Windows DOS FILE: str1 server1 a str1 server2 a str2 server1 b str2 server2 b Awk command: awk ' $1 ~/str1/ { print $2, $3 } ' file.txt OUTPUT: server1 a server2 a Thanks,

5. Shell Programming and Scripting

awk equivalent of regex

Hi all, Can someone tell me what's the (g)awk equal of this simple regex to find ip addresses in urls: egrep "^http://{1,3}\.{1,3}\.{1,3}\.{1,3}(:{1,5})?/"Input: http://10.0.0.1/query.exe http://11y10x09w:80/howaboutme http://192.168.100.190:1234/takeme.gpg Output:...

6. Shell Programming and Scripting

What is the equivalent of NR (awk) in perl?

Hello, I searched online; it seems that perl use $NR as NR in awk; however it does not work for me. For example, how to re-write the following awk using perl: awk '{ print NR}' inputfile---------- Post updated at 01:55 PM ---------- Previous update was at 12:49 PM ---------- I found...

7. Shell Programming and Scripting

awk equivalent code in C for printing NF

Hi all ! whether anyone in forum knows what awk will use while printing number of fields in file(NF) ? for example awk END'{print NF}' file prints number of columns in file if anyone knows equivalent code in C kindly share or explain logic behind it

8. Shell Programming and Scripting

Java - Arrays.binarySearch function equivalent in awk

Hi all Does anyone know Java-Arrays.binarySearch function equivalent in awk I tried like this but it's not correct one,it just returns array index if and only when searched value available in array, for some reason if searched value not found then I want to return upper nearest neighbour index....

9. Shell Programming and Scripting

sed Equivalent for awk/grep

Any equivalent command using awk or grep? sed -n "/^$(date --date='10 minutes ago' '+%b %_d %H:%M')/,\$p" /abc.log

10. UNIX for Beginners Questions & Answers

awk script Equivalent .

Hello. I wrote some code for an awk command but I want to learn to turn it into an awk script but am stuck. I have a file (data.csv) that has the following data: ADD,1,3,5,8,10,11,54 SUB,1,2,3,4 ADD,15,18,21,42,37 ADD,1,1,1,0,0,3,16 ADD,4,1,8,0,4,6,13,16,17,20,8,6,4 SUB,13,8If the line...