Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk equivalent script
Top Forums Shell Programming and Scripting awk equivalent script Post 302166183 by pondlife on Monday 11th of February 2008 07:50:23 AM
Old 02-11-2008
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.
 

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... (1 Reply)
Discussion started by: JackMelson
1 Replies

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... (1 Reply)
Discussion started by: vickramshetty
1 Replies

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)... (1 Reply)
Discussion started by: boy18nj
1 Replies

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, (1 Reply)
Discussion started by: phamp008
1 Replies

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:... (8 Replies)
Discussion started by: r4v3n
8 Replies

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... (2 Replies)
Discussion started by: littlewenwen
2 Replies

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 Replies)
Discussion started by: Akshay Hegde
8 Replies

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.... (1 Reply)
Discussion started by: Akshay Hegde
1 Replies

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 (7 Replies)
Discussion started by: timmywong
7 Replies

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... (5 Replies)
Discussion started by: Eric7giants
5 Replies

LEARN ABOUT DEBIAN

gsf

GSF(1)								       GNOME								    GSF(1)

NAME

       gsf - archiving utility using the G Structured File library

SYNOPSIS

       gsf [OPTION...] SUBCOMMAND ARCHIVE...

DESCRIPTION

       This manual page briefly documents the gsf command.

       gsf  is	a simple archive utility, somewhat similar to tar(1). It operates on files following one of the structured file formats understood
       by the G Structured File library, for example, Microsoft Excel(TM) files.

OPTIONS

   Options
       -?, --help
	      Show help options

       -v, --version
	      Display gsf's version

   Subcommands
       cat    Output one or more files in archive

       dump   Dump one or more files in archive as formatted hexadecimal

       help   List subcommands

       list   List files in archive

       props  Archive list of property names

EXAMPLES

       To list the content structure of a Microsoft Excel(TM) file arrays.xls:

       gsf list arrays.xls

       To dump Workbook, an individual data stream in arrays.xls:

       gsf dump arrays.xls Workbook

AUTHORS

       gsf's primary authors are Morten Welinder <terra@gnome.org> and Jody Goldberg <jody@gnome.org>.

       The initial version of this manpage was written by J.H.M. Dassen (Ray) <jdassen@debian.org>.

SEE ALSO

       gnumeric(1)

       The Gnumeric homepage <http://www.gnome.org/projects/gnumeric/>

       The GNOME project page <http://www.gnome.org/>

gsf								 29 November 2009							    GSF(1)
All times are GMT -4. The time now is 07:07 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy