Compare two arrays in sh or compare two fields


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Compare two arrays in sh or compare two fields
# 1  
Old 10-31-2007
Compare two arrays in sh or compare two fields

I want a soultion to compare two arrays in sh with an easy way.I want a solution to synchrose users between different AIX servers where no NIS is available. All users are meant to be same on all 10 servers. So the approach is to consider first server as master user repository and whatever the users are created on it has to extract in a format and use a tempate file for creating missing users on other servers by comparing values in template file with its /etc/passwd file.

Hence my template file creates on following command

`cat /etc/passwd | awk -F ':' '{printf("%-15s %-62s %-5s %-5s \n",$1,$5,$4,$6)}'` > allusers.txt

Which will have all the fields to create users.At the same time i need to remove the service accounts like root dameon etc from allusers.txt. So service accounts are already known and assigned into an variable.

SERVICE_ACCOUNTS="root daemon bin sys adm uucp nobody lpd lp invscout snapp ipsec nuucp sshd wasadmin db2inst1 dasusr1 db2fenc1 db2inst2 db2fenc2 vobadm gpausr"


Need to extract userlogin from allusers.txt by comparing SERVICE_ACCOUNTS.

createProjectUserTemplate()
{

#Find all users, Construct list and then compare with defined service account users list
`cat /etc/passwd | awk -F ':' '{printf("%-15s %-62s %-5s %-5s \n",$1,$5,$4,$6)}'` > allusers.txt
set -A serviceAccountsList $SERVICE_ACCOUNTS
#Construct user login from allusers
allUserLogins=`cut -f1 -d ' ' allusers.txt`
set -A totUserLoginsList $totUserLogins
#Differentiate two lists and find and construct Project user list and put into ProjectUserTemplate.txt file along with rest of the field
Need s suitable easy way of comaparing.
}

Can anyone help me to compare these values in an easy way as i am new to shell scripting. All i know is that we have to use sh or ksh becasue bash is not install on AIX by default.

I have seen another question almost similar to me on the link
Comparing Arrays? . But the solution given there is not working me when i cut userlogin field and then assigning to variable.

i.e. the problem in tha tway is

a1="root daemon bin sys adm uucp nobody lpd lp invscout snapp ipsec nuucp sshd wasadmin db2inst1 dasusr1 db2fenc1 db2inst2 db2fenc2 vobadm gpausr"
a2=`cut -f1 -d ' ' allusers.txt`

Then

a3=$(printf "$a1\n$a2"|awk '{for(i=1;i<=NF;i++)if(NR==1)a[$i]=i;else if(!($i in a))print $i}')

does not give me the difference as seems to be problem with cut. If there is a solution to this then aslo i will be grateful.

Thanks in advance,
Rijesh.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Is there a UNIX command that can compare fields of files with differing number of fields?

Hi, Below are the sample files. x.txt is from an Excel file that is a list of users from Windows and y.txt is a list of database account. $ head -500 x.txt y.txt ==> x.txt <== TEST01 APP_USER_PROFILE USER03 APP_USER_PROFILE TEST02 APP_USER_EXP_PROFILE TEST04 APP_USER_PROFILE USER01 ... (3 Replies)
Discussion started by: newbie_01
3 Replies

2. Shell Programming and Scripting

Using Diff to compare 2 arrays

I have two arrays and they look like this: array=(`cat /local/mnt/*sys/*includes|grep -v NEW`) array2=(`cat /tmp/*sys.z |grep -v NEW`) I am trying to compare them but I need to use the diff -u command. I am not sure how to do this. I cannot just do diff -u ${array} ${array2} I cannot... (4 Replies)
Discussion started by: newbie2010
4 Replies

3. Shell Programming and Scripting

awk - compare 1st 15 fields of record with 20 fields

I'm trying to compare 2 files for differences in a selct number of fields. When differnces are found it will write the whole record of the second file including appending '|C' out to a delta file. Each record will have 20 fields, but only want to do comparison of 1st 15 fields. The 1st field of... (7 Replies)
Discussion started by: sljnk
7 Replies

4. Shell Programming and Scripting

Compare two arrays

Hi, I am trying to compare two lists that are held in two variables so I believe I need to access the array elements to compare these. I am using ksh 88 and the code I have tried is below: for file in ${origfilelist} do if ]] then print -- "File ${file}... (3 Replies)
Discussion started by: frodo61
3 Replies

5. Shell Programming and Scripting

perl: compare two arrays

Hi friends, I want to compare two arrays and find matched one using perl? Also, I want to delete unmatched one. Plz suggest me solution (1 Reply)
Discussion started by: Renesh
1 Replies

6. Shell Programming and Scripting

Perl Compare 2 Arrays

Hello, Consider the following 2 arrays: Array1 = qw(Fa0/0 Fa0/1 Fa0/2 Fa0/3); Array1 = qw(Fa0/1 Fa0/2 Fa0/3 Fa0/4); I want to compare the following 2 arrays as follows: Take specific action when elements of Array1 that doesn't exist in Array2 (in my example: Fa0/0). Take another... (4 Replies)
Discussion started by: ahmed_zaher
4 Replies

7. Shell Programming and Scripting

Compare arrays (perl)

Hi, my first post here! Description of my problem: I have one txt-file with six rows and each row contains seven numbers seperated with whitespaces. I want to: Compare one array with seven numbers with each row of numbers in the txt-file. I have managed to compare one array with... (6 Replies)
Discussion started by: mjoh
6 Replies

8. Shell Programming and Scripting

compare 2 arrays in perl

Hi Im supposed to compare lines in a file : KB0005 1019 T IFVATVPVI 0.691 PKC YES KB0005 1036 T YFLQTSQQL 0.785 PKC YES KB0005 1037 S FLQTSQQLK 0.585 DNAPK YES KB0005 1045 S KQLESEGRS 0.669 PKC YES KB0005 1045 S KQLESEGRS 0.880 unsp YES KB204320 1019 T IFVATVPVI 0.699 PKC YES ... (7 Replies)
Discussion started by: karla
7 Replies

9. Shell Programming and Scripting

Compare arrays in perl

Hello, Let's say that we have the two following arrays @array1= @array2= Is there any easy way to compare these two arrays and print the values that exist in array1 and not in array2 and the values that exist in array2 and not in array1? Regards, Chriss_58 (3 Replies)
Discussion started by: chriss_58
3 Replies

10. Shell Programming and Scripting

Perl - Compare 2 Arrays

Hi all, I have the following script where the contents of file1 and file2 would be something like this: file1: 56790,0,0,100998765 89756,0,0,100567876 867645,1,3,678777654 file2: 56790,0,0,100998765 65776,0,0,4766457890 +5896,0,0,675489876 What I then want to do is check if... (4 Replies)
Discussion started by: Donkey25
4 Replies
Login or Register to Ask a Question