Sponsored Content
Top Forums Shell Programming and Scripting Compare two arrays in sh or compare two fields Post 302143191 by rijeshpp on Wednesday 31st of October 2007 02:47:02 AM
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.
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
ARRAY_DIFF_ASSOC(3)							 1						       ARRAY_DIFF_ASSOC(3)

array_diff_assoc - Computes the difference of arrays with additional index check

SYNOPSIS
array array_diff_assoc (array $array1, array $array2, [array $...]) DESCRIPTION
Compares $array1 against $array2 and returns the difference. Unlike array_diff(3) the array keys are also used in the comparison. PARAMETERS
o $array1 - The array to compare from o $array2 - An array to compare against o $... - More arrays to compare against RETURN VALUES
Returns an array containing all the values from $array1 that are not present in any of the other arrays. EXAMPLES
Example #1 array_diff_assoc(3) example In this example you see the "a" => "green" pair is present in both arrays and thus it is not in the output from the function. Unlike this, the pair 0 => "red" is in the output because in the second argument "red" has key which is 1. <?php $array1 = array("a" => "green", "b" => "brown", "c" => "blue", "red"); $array2 = array("a" => "green", "yellow", "red"); $result = array_diff_assoc($array1, $array2); print_r($result); ?> The above example will output: Array ( [b] => brown [c] => blue [0] => red ) Example #2 array_diff_assoc(3) example Two values from key => value pairs are considered equal only if (string) $elem1 === (string) $elem2 . In other words a strict check takes place so the string representations must be the same. <?php $array1 = array(0, 1, 2); $array2 = array("00", "01", "2"); $result = array_diff_assoc($array1, $array2); print_r($result); ?> The above example will output: Array ( [0] => 0 [1] => 1 ) NOTES
Note This function only checks one dimension of a n-dimensional array. Of course you can check deeper dimensions by using, for example, array_diff_assoc($array1[0], $array2[0]);. Note Ensure you pass arguments in the correct order when comparing similar arrays with more keys. The new array should be the first in the list. SEE ALSO
array_diff(3), array_diff_uassoc(3), array_udiff_assoc(3), array_udiff_uassoc(3), array_intersect(3), array_intersect_assoc(3). PHP Documentation Group ARRAY_DIFF_ASSOC(3)
All times are GMT -4. The time now is 02:45 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy