shell script comparing files in a file

raina_nalin · #1 (**permalink**) 06-20-2005

There is a text file that contains the data in the following format:

COLUMN1 COLUMN2
ABC 1
ABC 2
ABC 3
DEF 4
DEF 5
XYZ 7

We have to create a second text file by reading the above file in the following format:

COLUMN1 COLUMN2
ABC 1,2,3
DEF 4,5
XYZ 7

I am new to unix scripting!Kindly help !!!!!

vgersh99 · #2 (**permalink**) 06-20-2005

nawk -f raina.awk textFile

raina.awk:

Code:

{
  arr[$1] = ($1 in arr) ? arr[$1] "," $2 : $2
}
END {
  for (i in arr)
    print i, arr[i]
}

raina_nalin · #3 (**permalink**) 06-21-2005

Hello,
Thanks for the effort !
However,I am getting the following output :

ABC 1 1
ABC 2 2
ABC 3 3
XYZ 7 7
DEF 4 4
DEF 5 5

when the input file contained the data as mentioned in the problem.

Also,I could not use "nawk"--It said that --- command not found!

Thanks !

raina_nalin · #4 (**permalink**) 06-21-2005

THANKS A TON !
PLEASE IGNORE MY PREVIOUS REPLY..I HAD REPLACED $1 BY $i..SO WAS NOT WORKING :-)
ITS WORKING NOW.

THANKS !

pixelbeat · #5 (**permalink**) 06-21-2005

Here's some python for ya:

Code:

#!/usr/bin/env python
                                                                                                          
import sys
                                                                                                          
groups={}
                                                                                                          
while 1:
     line = sys.stdin.readline()
     if line == '':
         break
     try:
         key,value=line.strip().split()
         if not groups.has_key(key):
            groups[key]=[value]
         else:
            groups[key].append(value)
     except:
         pass
                                                                                                          
keys=groups.keys()
keys.sort()
for key in keys:
    print key,
    print ",".join(groups[key])

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
shell script to remove old files and write to a log file	yabai	Shell Programming and Scripting	4	12-09-2008 01:08 PM
How can i prepare a file by comparing two other files?	manmohanpv	Shell Programming and Scripting	3	02-18-2008 04:58 AM
comparing PID values of 2 Files in shell Options	marconi	Shell Programming and Scripting	2	12-19-2007 01:02 PM
Script error.. for comparing 2 files!	gkrishnag	UNIX for Advanced & Expert Users	4	09-13-2006 09:19 AM
comparing files to contents of a file	SummitElse	Shell Programming and Scripting	3	06-28-2006 12:36 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: