Using input from one file to define scope of other file in Linux Post: 302938323

Sponsored Content

Top Forums Shell Programming and Scripting Using input from one file to define scope of other file in Linux Post 302938323 by Zooma on Saturday 14th of March 2015 10:51:48 AM

03-14-2015

Registered User

Right again Don. Tried to print it as a decimal number but now it's fixed. I'm gonna download awk/bash tutorials and spend next week reading! Anyway, thanks a lot for all help. Posting the final script below where I also added ping counts and the URL.

I guess an infile with 10 000 rows containing 10 addresses in total would write URLs the name[$1] array 10 000 times. Could be done with a separate awk command for the URL only but this is good enough for me.

Now the infile syntax is:

Code:

<IP Address to ping> <ping time> <URL>

And the code that produces the stats:

Code:

awk '
{       if(!($1 in c)) m[$1] = M[$1] = $2
        else    if($2 > M[$1]) M[$1] = $2
        else    if($2 < m[$1]) m[$1] = $2
        s[$1] += $2
        name[$1] = $3
        c[$1]++
}

END {   printf("%-17s %3s %-5s %3s %3s %5s %5s\n", "   IP Address", "Min", " Ave",
                "Max", "PDV", "count", "URL")
        printf("%17s %3s %5s %3s %3s %5s %5s\n", "=================", "===", "=====",
                "===", "===", "=====", "===")
        for(i in c)
                printf("%-17s %3d %5.1f %3d %3d %5d %5s\n", i, m[i], s[i] / c[i], M[i],
                        M[i] - m[i], c[i], name[i])
}' $1

Thanks a lot Don. Appreciated!

Zooma

View Public Profile for Zooma

Find all posts by Zooma

10 More Discussions You Might Find Interesting

1. Solaris

define .rhost file for tape backup to remote host

howdy experts, i am using 2 server- Solaris 5.9 i have tape device attached with 1 of my solaris server. But others not. # modinfo|grep tape 152 13d43e4 1333c 33 1 st (SCSI tape Driver 1.231) now i want to Backup DATA file and System File in Tape Drive. How do I take data and...

2. Shell Programming and Scripting

Problem in define cpu in Rules file

i try to install solaris OS in M4000 using OK prompts by boot net . in my rules file i define the cpus like below probe cpus probe networks networks 2 && cpus 8-10 && disksize c0t0d0 100000-292000 && disksize c0t1d0 100000-292000 && memsize 16384 && model SUNW,SPARC-Enterprise...

3. Programming

which head file define '_IO_*'

Under Solaris 10,I compile following file, #include <sys/types.h> #include <sys/stat.h> #include <sys/termios.h> #include <sys/ioctl.h> #include <stdio.h> #include <stdlib.h> #include <stddef.h> #include <string.h> #include <unistd.h> #include <signal.h> #define _IO_UNBUFFERED __SNBF...

4. Shell Programming and Scripting

Need script to take input from file, match on it in file 2 and input data

All, I am trying to figure out a script to run in windows that will allow me to match on First column in file1 to 8th Column in File2 then Insert file1 column2 to file2 column4 then create a new file. File1: 12345 Sam 12346 Bob 12347 Bill File2:...

5. UNIX for Dummies Questions & Answers

How to define input files more than 9

awk -v nfiles="10" { ......................... ............ }' $1 $2 $3 $4 $5 $6 $7 $8 $9 $10 up to9 inputs script is running fine but after that it is throwing error file not found though there is a file. I used {$10} but no use.

6. Shell Programming and Scripting

The scope of the shell/perl script is to read the input text file. Validate the expiry date of each

The scope of the shell/perl script is to read the input text file. Validate the expiry date of each certificate and send the mail to the user. The user takes action to add the new certificate to the storage file and user owns the responsibility to update the input text file with the new certificate...

7. Shell Programming and Scripting

Define variable from file.

HI I have file A.txt _1A _2A _3A _4A I want define all as different variable. $1A=_1A $2B=_2A $3C=_3A $4D=_4A Now i can use any variable in my script.

8. UNIX for Advanced & Expert Users

Passwd file define user with special character

Hi all , The FTP user defind in my passwd file has ! in the hash password field and i want to know way is that its usually either MD5(Unix) hash or * can anyone explain to me i'm new for unix and want to learn this how my passwd file looks : ...

9. Shell Programming and Scripting

How to define a variable in a BASH script by using a JSON file online?

Hello, I would like to modify an existing script of mine that uses a manually defined "MCVERSION" variable and make it define that variable instead based on this JSON file stored online: https://s3.amazonaws.com/Minecraft.Download/versions/versions.json Within that JSON, I 'm looking for...

10. UNIX for Beginners Questions & Answers

Bash Variable scope - while loop while reading from a file

Cope sample1: test.sh i=0 echo " Outside loop i = $i " while do i=$(( $i + 1)) echo "Inside loop i = $i " done echo " Out of loop i is : $i " When run output : Outside loop i = 0 Inside loop i = 1 Inside loop i = 2 Inside loop i = 3 Inside loop i = 4 Inside loop i = 5 Inside...

LEARN ABOUT XFREE86

urlcoding

URLCODING(3)						 libbash urlcoding Library Manual					      URLCODING(3)

NAME

     urlcoding -- a Libbash library for encoding and decoding URL's.

SYNOPSIS

     urlEncodeString [-l] <STRING>
     urlEncodeFile [-l] <FILE>
     urlEncodeStream [-l]
     urlDecodeString <STRING>
     urlDecodeFile <FILENAME>
     urlDecodeStream

DESCRIPTION

     urlcoding is a collection of functions that convert ASCII-text to standard URL's and vice-versa. The AWK code used is based on code by Heiner
     Steven <heiner.steven@odn.de>

     The function list:
	   urlEncodeString  Creates a URL from an ASCII string
	   urlEncodeFile    Converts a file into URL-valid text
	   urlEncodeStream  Converts standard input into URL-valid text
	   urlDecodeString  Converts a URL-encoded text back to a plain-text form
	   urlDecodeFile    Coverts URL-encoded text in a file back to plain text
	   urlDecodeStream  Converts URL-encoded standard input to text

     Detailed interface description follows.

     The [-l] option for the encoding functions should be used when line-feed characters ('
') are to be encoded as well.

     All functions print the results of their conversions to standard output.

     The exit status of all functions is that of the command 'awk', with '0' for success

FUNCTIONS DESCRIPTIONS

   urlEncodeString [-l] <STRING>
     Converts STRING - a string of ASCII characters - to URL.

   urlEncodeFile [-l] <FILE>
     Coverts FILE of URL-encoded text to plain text

   urlEncodeStream [-l]
     Converts text from standard input to URL-text.

   urlDecodeString <STRING>
     Converts URL-encoded string STRING back to text.

   urlDecodeFile <FILENAME>
     Converts the URL-encoded text in FILE to plain text.

   urlDecodeStream
     Converts the URL-encoded text from standard input to plain-text

AUTHORS

     Alon Keren <alon.keren@gmail.com>

SEE ALSO

     ldbash(1), libbash(1)

Linux								       Epoch								     Linux

10 More Discussions You Might Find Interesting

1. Solaris

define .rhost file for tape backup to remote host

Discussion started by: thepurple

2. Shell Programming and Scripting

Problem in define cpu in Rules file

Discussion started by: neruppu

3. Programming

which head file define '_IO_*'

Discussion started by: konvalo

4. Shell Programming and Scripting

Need script to take input from file, match on it in file 2 and input data

Discussion started by: darkoth