Comparing 2 file use c shell script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Comparing 2 file use c shell script
# 1  
Old 09-23-2010
Comparing 2 file use c shell script

Hi all,
I got 2 file :

file1:
Quote:
path1 4 group1
path2 6 group2
path3 10 group1
path4 6 group2
file2:
Quote:
group1 email1
group2 email2
output:
Quote:
path1 4 group1 email1
path2 6 group2 email2
path3 10 group1 email1
path4 6 group2 email2
But , must write out in C shell.Anybody can help solve?
# 2  
Old 09-24-2010
Please post what you have tried so far. Is this homework?
# 3  
Old 09-24-2010
Hi, this is not homework . I assign to done this task in my job. I only success loop the 1st file. Then i want loop 2nd file i fail .
This is the code i done until now:
Code:
#!/bin/csh

set app_dir = "/ebsxe/ebs25/users/mmlim/assignment01"

set line_array = (`cat $app_dir/config_path`)
set line_array_2 =(`cat $app_dir/config_recipient`)

@ index1 = 1
@ index2 = 2
@ index3 = 3

@ lot1 = 1
@ lot2 = 2

while ( $index1 && $index2 && $index3 <= $#line_array )

        set dir = $line_array[$index1]
        set limit = $line_array[$index2]
        set class = $line_array[$index3]

        cd $dir
        set filecount = ( `ls -1 | wc -l` )

        if ( $filecount <= $limit ) then
                while ( $lot1 && $lot2 <= $#line_array_2 )
                set group = $line_array_2[$lot1]
                set email = $line_array_2[$lot2]

                if ( $class == $group )then
                echo " $class "
                endif

                @ lot1 += 2
                @ lot2 += 2
                end

        else
        echo " $class "
        endif

        @ index1 += 3
        @ index2 += 3
        @ index3 += 3

end

However when i include this code :
Code:
 while ( $lot1 && $lot2 <= $#line_array_2 )
                set group = $line_array_2[$lot1]
                set email = $line_array_2[$lot2]

                if ( $class == $group )then
                echo " $class "
                endif

My script load problem occur.
# 4  
Old 09-24-2010
The similar question was asked nearly every week.

Code:
awk 'NR==FNR{a[$1]=$2;next} {if ($3 in a) print $0,a[$3]}' file2 file1

# 5  
Old 09-24-2010
hi rdcwayx,
This code can use in C shell?

awk 'NR==FNR{a[$1]=$2;next} {if ($3 in a) print $0,a[$3]}' file2 file1$1 and $ 2 represent what variable?
# 6  
Old 09-24-2010
$1 and $2 is represented the first file (file2)'s column 1 and column 2.
# 7  
Old 09-24-2010
hi rdcwayx,
but ur 1 cannot run in my script. I be compulsary to done in C shell script.
Ho i want replace this statement with awk :
Code:
 while ( $lot1 && $lot2 <= $#line_array_2 )
                set group = $line_array_2[$lot1]
                set email = $line_array_2[$lot2]

                if ( $class == $group )then
                echo " $class "
                endif

In this statement i loop inside file2
and see group in file1 == file2 then just come out email
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Shell script needed for comparing two files

Hi, I need shell script to compare the two files based on certain fields and output should contains the required fields based on result.pls find sample input files and required output file 1 COUNT, BNG_IP,PORT,OVLAN 22 , 10.238.60.129,1/1,2009 144 , 10.238.60.129,1/1,2251 ... (5 Replies)
Discussion started by: surender reddy
5 Replies

2. Shell Programming and Scripting

Comparing dates in shell script

Hi All, I have a date variable say dt="2014-01-06 07:18:38" Now i need to use this variable to search a log and get the entries which occured after that time. (1 Reply)
Discussion started by: Girish19
1 Replies

3. Shell Programming and Scripting

shell script for comparing two files

Hi, I have 2 files as below FILE1.dat co1|co2|co3 abnd|45.56|AZ dkny|30.2|PA sam|.23|VA FILE.CTL FILENAME|FILE1.dat NO OF RECORDS|3 CHECKSUM|75.99 Could you please help me to write a shell script to compare 1. TOTAL RECORDS from FILE1.dat with NO of RECORDS in FILE.CTL 2.... (8 Replies)
Discussion started by: dreamsportsteam
8 Replies

4. Shell Programming and Scripting

Comparing 2 files using shell script

Hi Experts, I have 2 files 1 file consists of 800 records and 2 file consists of 100 records with matching column as Membership_Num.So i need a script which will compare the 2 files and displays the output.As these are the files the script should take any delimter like (tab,comma) as input... (6 Replies)
Discussion started by: naveen.dasu
6 Replies

5. Shell Programming and Scripting

Comparing two array in shell script

In shell script i have two variables with value debit_sal="DOG,HIU,JIU,GYT,PPI,KIU,HUY........." debit_req='HIU, JIU, HUY, GTR, KOI, ............" i stored this two in two array arr=$(echo $debit_sal| tr "," "\n"); arr1=$(echo $debit_req| tr ", " "\n"); #(note second arry has comma with... (5 Replies)
Discussion started by: greenworld123
5 Replies

6. Shell Programming and Scripting

comparing 2 files in shell script

I have 2 files config1h.txt ----------------- BFMU=ENABLE,ID=PM THR=OFF,REP=ALL,CON=IACM,TIM=OFF;GPON collection strategy 1.3.6.1.2.1.2.2:8 1.3.6.1.2.1.2.2:7 1.3.6.1.4.1.637.61.1.35.11.4:4 1.3.6.1.4.1.637.61.1.35.11.4:3 1.3.6.1.4.1.637.61.1.35.10.1:2 1.3.6.1.4.1.637.61.1.35.10.1:43... (7 Replies)
Discussion started by: LavanyaP
7 Replies

7. Shell Programming and Scripting

Comparing Alphanumeric Variables in Shell Script

Can someone please help me out here? I have strings similar to aafafaff45,29.34.942.45,edfdfafa that i want to compare to another similar string to check if they are the same. my script isn't working. ONE="aafafaff45,29.34.942.45,edfdfafa" TWO="ddfafagfa,87.57.942.45,afafafff" if ONE is... (5 Replies)
Discussion started by: SkySmart
5 Replies

8. Shell Programming and Scripting

comparing two files using shell script

hi experts please help me to compare two files which are in different directory file1<file will be master file> (/home/rev/mas.txt} ex x1 x2 file2 <will be in different folder> (/home/rev/per/.....) ex x3 x4 the filesinside per folder i need to compare with master file and the files... (2 Replies)
Discussion started by: revenna
2 Replies

9. UNIX for Dummies Questions & Answers

shell script for comparing 2 files

Hi, how to read the 2 files and compare each other in shell script? i have 2 files test1 and test2, both files contains 20 character records.we have to compare file 1 records with file2, if exists then reject the record else we have to append it to test2 file. in file test1 around 100 single... (2 Replies)
Discussion started by: prashanth.spl
2 Replies

10. Shell Programming and Scripting

shell script comparing files in a file

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... (4 Replies)
Discussion started by: raina_nalin
4 Replies
Login or Register to Ask a Question