Need help comparing two files and deleting some things in those files! Post: 302440411

Sponsored Content

Top Forums Shell Programming and Scripting Need help comparing two files and deleting some things in those files! Post 302440411 by linuxkid on Tuesday 27th of July 2010 06:33:49 AM

07-27-2010

Registered User

Quote:

Originally Posted by rdcwayx

Code:

awk 'NR==FNR {for (i=2;i<=NF;i+=2) a[$1 FS $i]=$(i+1) ;next}
     {for (i in a)
        {split(i,s,FS)
       if ($2>$3) {t=$3;$3=$2;$2=t}
        if (s[1]==$1 && s[2]>=$2 && s[2]<=$3 ) print i,a[i]|"sort -nr"}
     }' File2 File1
 
treehouse.txt 1.9 ref4738
treehouse.txt 1.8 ref4573
treehouse.txt 1.7 ref3232
treehouse.txt 1.12 ref8573
pictures.txt 1.3 ref5432
pictures.txt 1.2 ref4244
pictures.txt 1.1
dance.txt 1.4 ref0695
dance.txt 1.3 ref5738
dance.txt 1.2 ref4948

Code:

awk 'NR==FNR {for (i=2;i<=NF;i+=2) a[$1 FS $i]=$(i+1) ;next}
     {for (i in a)
        {split(i,s,FS)
        if ($2>$3) {t=$3;$3=$2;$2=t}
        if (s[1]==$1 && s[2]>=$2 && s[2]<=$3 ) print i,a[i]|"sort -nr"}
     }' File2 File1 |awk '!a[$1] {printf RS $1 FS;a[$1]=1} {printf $2 FS $3 FS}'
 
treehouse.txt 1.9 ref4738 1.8 ref4573 1.7 ref3232 1.12 ref8573
pictures.txt 1.3 ref5432 1.2 ref4244 1.1
dance.txt 1.4 ref0695 1.3 ref5738 1.2 ref4948

this doesn't print out anything between 1.9 and 1.12 though, is there anyway we can change it to do so? and IF possible, arrange the output so it retains its order of highest version number to lowest? many thanks

linuxkid

View Public Profile for linuxkid

Find all posts by linuxkid

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

comparing shadow files with real files

Hi I need to compare shadow file sizes with their real file counterparts. If the shadow file size differs form the realfile size then it must send a mail. My problem is that our system has over 1600 shadowfiles in different directories, with different names. the only consistancy is the .sh file...

2. UNIX for Dummies Questions & Answers

Deleting the files comparing the creation dates

Hi Gurus, I am new to unix. I have a requirement where i need to delete some files in a folder twice a week. Suppose i have a folder AAA. In that i have files from 01/04/2008 to 10/04/2008 I want to remove all the files except last 3 days i.e., 10,9th & 8th. Every week twice we want to...

3. Shell Programming and Scripting

AIX system.... deleting files in remote directory after retrieving files

Hi Friends, I am new to this , I am working on AIX system and my scenario is to retrive the files from remote system and remove the files from the remote system after retreving files. I can able to retrieve the files but Can't remove files in remote system. Please check my code and help me out...

4. Shell Programming and Scripting

Comparing the matches in two files using awk when both files have their own field separators

I've two files with data like below: file1.txt: AAA,Apples,123 BBB,Bananas,124 CCC,Carrot,125 file2.txt: Store1|AAA|123|11 Store2|BBB|124|23 Store3|CCC|125|57 Store4|DDD|126|38 So,the field separator in file1.txt is a comma and in file2.txt,it is | Now,the output should be...

5. UNIX for Advanced & Expert Users

How to find duplicates contents in a files by comparing other files?

Hi Guys , we have one directory ...in that directory all files will be set on each day.. files must have header ,contents ,footer.. i wants to compare the header,contents,footer ..if its same means display an error message as 'files contents same'

6. Shell Programming and Scripting

Comparing files in a directory against an array of files

I hope I can explain this correctly. I am using Bash-4.2 for my shell. I have a group of file names held in an array. I want to compare the names in this array against the names of files currently present in a directory. If the file does not exist in the directory, that is not a problem....

7. Shell Programming and Scripting

Bash script deleting my files, and editing files in subdirectories question

#!/bin/bash # name=$1 type=$2 number=1 for file in ./** do if then filenumber=00$number elif then filenumber=0$number fi tempname="$name""$filenumber"."$type" if

8. Shell Programming and Scripting

Trying to make a bash script that goes through directory files and changes things

I'm trying to write a script in a directory that goes through the column the user specifies of 4 files that are inside the directory and calculates the min and the max values. This means that if the user specifies column 5, the script will go through column 5 of all 4 files and all that should give...

9. UNIX for Beginners Questions & Answers

Comparing two files and list the difference with common first line content of both files

I have two file as given below which shows the ACL permissions of each file. I need to compare the source file with target file and list down the difference as specified below in required output. Can someone help me on this ? Source File ************* # file: /local/test_1 # owner: own #...

LEARN ABOUT DEBIAN

pclock

PCLOCK(1)						      General Commands Manual							 PCLOCK(1)

NAME

       pclock - pixmap clock

SYNOPSIS

       pclock [options]

DESCRIPTION

       This  manual  page  documents  briefly  the pclock command.  This manual page was written for the Debian GNU/Linux distribution because the
       original program does not have a manual page.

       pclock is a program that places a small analog clock program on the desktop of X.  It was designed to run under the WindowMaker window man-
       ager.  It uses any 64x64 pixmap as a background.

OPTIONS

       The programs follow the usual GNU command line syntax, with long options starting with two dashes (`-') and short optoins starting with one
       dash.  A summary of options is included below.

       -B PIXMAP, --background=PIXMAP
	      Use the given pixmap as the clock background (size must be 64x64).

       -H COLOR, --hands-color=COLOR
	      Draw the hands (hour, minute and second) in the specified color.

       -S COLOR, --second-hand-color
	      Draw the second hand in the specified color

       -h, --help
	      Show summary of options.

       --hour-hand-length=INT
	      Draw the hour hand with the specified length of INT.

       --minute-hand-length=INT
	      Draw the minute hand with the specified length of INT.

       --second-hand-length=INT
	      Draw the second hand with the specified length of INT.

       --second-hand-width=INT
	      Draw the minute hand with the specified width of INT.

       -s, --second-hand
	      Don't display the second hand.

       -v, --version
	      Show version of program.

       -w, --withdrawn
	      Don't start up in a withdrawn (iconic) state.

AUTHOR

       This manual page was written by Darren Benham <gecko@debian.org>, for the Debian GNU/Linux system (but may be used by others).	The  soft-
       ware is copyrighted (c) 1998 by and released under the GPL v2.

       Author: Alexander Kourakos <Alexander@Kourakos.com>
	  Web: http://www.kourakos.com/~awk/pclock/

																	 PCLOCK(1)