Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with gawk script that aggregates ip address ranges
Top Forums Shell Programming and Scripting Help with gawk script that aggregates ip address ranges Post 302333675 by summer_cherry on Monday 13th of July 2009 09:40:08 PM
Old 07-13-2009
Code:
use strict;
my %hash;
while(<DATA>){
	chomp;
	my @tmp=split("[.]",$_);
	map {$_=sprintf("%03d",$_)} @tmp;
	my $key = sprintf("%s.%s.%s",$tmp[0],$tmp[1],$tmp[2]);
	push @{$hash{$key}}, $tmp[3];
}
foreach my $key (sort keys %hash){
	my @tmp=@{$hash{$key}};
	@tmp=sort @tmp;
	print $key,".",$tmp[0],"--",$key,".",$tmp[$#tmp],"\n";
}
__DATA__
1.1.1.1
2.2.2.2
1.1.1.2
4.4.4.3
1.1.1.3
3.3.3.3
4.4.4.4
2.2.2.3

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to use variables and gawk in a script?

Hi, I want to define variables in a shell script and make gawk use them to make some operations Mfn = $(grep " 1 " $fitxer | gawk '{print $2}') Xfn = $(grep " 1 " $fitxer | gawk '{print $3}') Yfn = $(grep " 1 " $fitxer | gawk '{print $4}') Zfn = $(grep " 1 " $fitxer | gawk... (9 Replies)
Discussion started by: pau
9 Replies

2. UNIX for Dummies Questions & Answers

Calculating field using AWK, or GAWK script

Hello all, I'm totally new to UNIX/Linux but I'm taking a course in it at my local JC. My question: I have been tasked with writing a gawk script that will create a nicely formatted report. That part I've done ok on...however, the very last thing that must be done is a calculation of a... (4 Replies)
Discussion started by: Trellot
4 Replies

3. Shell Programming and Scripting

gawk script

Hey guys need your help with an gawk script... here's what I have so far gawk '^d/ {printf "%-20s %-10s %-10s %-10s %-4s%2s %5s\n",$9,$1,$3,$4,$6,$7,$8}' ls.kbr The file ls.kbr is a capture of 'ls-al' What I want gawk to do is: 1) Find only directories (this is working) 2) skip lines... (2 Replies)
Discussion started by: zoo591
2 Replies

4. Shell Programming and Scripting

Issues with filtering duplicate records using gawk script

Hi All, I have huge trade file with milions of trades.I need to remove duplicate records (e.g I have following records) 30/10/2009,trdeId1,..,.. 26/10/2009.tradeId1,..,..,, 30/10/2009,tradeId2,.. In the above case i need to filter duplicate recods and I should get following output.... (2 Replies)
Discussion started by: nmumbarkar
2 Replies

5. Programming

need help with gawk script

hi i've already created this script. When I execute the script it takes the argument and compares it to the 3rd column of the script. What I was wondering if I could get some help with is. I want to add another column to the script and it will be the result of a set number for example, (2000 - 3rd... (3 Replies)
Discussion started by: gengar
3 Replies

6. Windows & DOS: Issues & Discussions

Gawk Script in Windows batch file - Help

Good morning all. I have been running into a problem running a simple gawk script that selects every third line from an input file and writes it to an output file. gawk "NR%3==0" FileIn > FileOut I am attempting to run this command from a batch file at the command line. I have several hundred... (6 Replies)
Discussion started by: 10000springs
6 Replies

7. Shell Programming and Scripting

Help with gawk array, loop in tcsh script

Hi, I'm trying to break a large csv file into smaller files and use unique values for the file names. The shell script i'm using is tcsh and i'm after a gawk one-liner to get the desired outcome. To keep things simple I have the following example with the desired output. fruitlist.csv apples... (6 Replies)
Discussion started by: theflamingmoe
6 Replies

8. Shell Programming and Scripting

Search IP Address in list of ranges -- not working great

I have been struggling with a script to automate some security related activities. I have it pretty much working, all except the search. I have an input file formatted as such: 216.234.246.158 216.234.246.158 `` 24.249.221.22 24.249.221.200 `` 24.249.226.0 ... (4 Replies)
Discussion started by: tsunami4u
4 Replies

9. Shell Programming and Scripting

[BASH] Gawk + MYSQL script

Hello! I've got script to write. It should read databases (names, volumes) from table testdatabase and compares it to actually existing databases in /var/lib/mysql/. If there is no informations about database in table - we should see information "There is no declared informations about database... (1 Reply)
Discussion started by: Zimny
1 Replies

10. Shell Programming and Scripting

Gawk program not working in a script

I've written a very simple gawk program which runs when I execute it at the POSIX shell but the corresponding '.awk' script I wrote doesn't return any data. I'm on an HP-UX running gawk version 3.1. (w/all the defaults) (As you can probably guess I'm a newbie going through the manual and trying... (2 Replies)
Discussion started by: RUCerius
2 Replies

LEARN ABOUT DEBIAN

shtool-path

SHTOOL-PATH.TMP(1)					      GNU Portable Shell Tool						SHTOOL-PATH.TMP(1)

NAME

       shtool-path - GNU shtool command dealing with shell path variables

SYNOPSIS

       shtool path [-s|--suppress] [-r|--reverse] [-d|--dirname] [-b|--basename] [-m|--magic] [-p|--path path] str [str ...]

DESCRIPTION

       This command deals with shell $PATH variables. It can find a program through one or more filenames given by one or more str arguments.  It
       prints the absolute filesystem path to the program displayed on "stdout" plus an exit code of 0 if it was really found.

OPTIONS

       The following command line options are available.

       -s, --suppress
	   Supress output. Useful to only test whether a program exists with the help of the return code.

       -r, --reverse
	   Transform a forward path to a subdirectory into a reverse path.

       -d, --dirname
	   Output the directory name of str.

       -b, --basename
	   Output the base name of str.

       -m, --magic
	   Enable advanced magic search for ""perl"" and ""cpp"".

       -p, --path path
	   Search in path. Default is to search in $PATH.

EXAMPLE

	#   shell script
	awk=`shtool path -p "${PATH}:." gawk nawk awk`
	perl=`shtool path -m perl`
	cpp=`shtool path -m cpp`
	revpath=`shtool path -r path/to/subdir`

HISTORY

       The GNU shtool path command was originally written by Ralf S.  Engelschall <rse@engelschall.com> in 1998 for Apache. It was later taken
       over into GNU shtool.

SEE ALSO

       shtool(1), which(1).

18-Jul-2008							   shtool 2.0.8 						SHTOOL-PATH.TMP(1)
All times are GMT -4. The time now is 11:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy