Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk sum of 2 arrays and compare
Top Forums UNIX for Beginners Questions & Answers awk sum of 2 arrays and compare Post 303040610 by chofred on Friday 1st of November 2019 07:28:28 PM
Old 11-01-2019
awk sum of 2 arrays and compare
i'm new to awk, and i've been searching on the forum for sum of a column but all the scripts does sum a column of an entire file.

I've a file like this:

Code:
cat file.txt

1234 5678
5678 1234

I want to use awk to do sum of each column per line not entire file, compare the two then write the result on third, should look like this


Code:
1234 5678 col2 #awk do sum 1234 which is 10 then compare with sum of 5678 which is 26, 26 greater than 10, write col2
5678 1234 col1 #awk sum 5678 which is 26 then compare with sum 1234 which is 10, 26 greater than 10, write col1


that would compare every two arrays in a line.


Take it further, if I collapsed all the lines into one line, how the script would change to compare for every two columns.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

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... (0 Replies)
Discussion started by: rijeshpp
0 Replies

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

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

4. Shell Programming and Scripting

Compare strings between 2 arrays and print number in AWK

Hi to everyone, Please some help over here. Hi have array a with 6 elements and array b with 3 elements as shown inside BEGIN{} statement. I need help to get the correct sintax (the part in red) to compare if string from array b is in array a and print the number related for each match.... (3 Replies)
Discussion started by: Ophiuchus
3 Replies

5. Shell Programming and Scripting

How do I find the sum of values from two arrays?

Hi I have redc containing the values 3, 6, 2, 8, and 1. I have work containing the values 8, 2, 11, 7, and 9. Is there a way to find the sum of redc and work? I need to compare the sum of those two arrays to something else, so is it okay to put that into my END? TY! (4 Replies)
Discussion started by: razrnaga
4 Replies

6. Shell Programming and Scripting

awk arrays - compare value in second column to variable

Hello, I am trying to redirect files to a directory by using a config file. The config files is as such: xxxxxx,ID,PathToDirectory xxxxxx,ID2,PathToDirectory2 and so on... I have a variable that should match one of these IDs. I want to load this config file into an awk array, and... (2 Replies)
Discussion started by: jrfiol
2 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

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

9. Shell Programming and Scripting

Compare multiple arrays elements using awk

I need your help to discover missing elements for each box. In theory each box should have 4 items: ITEM01, ITEM02, ITEM08, and ITEM10. Some boxes either have a missing item (BOX02 ITEM08) or might have da duplicate item (BOX03 ITEM02) and missing another one (BOX03 ITEM01). file01.txt ... (2 Replies)
Discussion started by: alex2005
2 Replies

10. Shell Programming and Scripting

Sum elements of 2 arrays excluding labels

I'm looking for an efficient way to sum elements from 2 arrays using AWK and preserve header as well as sample names in the output array. I have Ubuntu 16.04 LTS. For example; ARRAY 1 SAMPLE DERIVED ANCESTRAL Sample1 14352 0 Sample2 14352 0 Sample3 14352 0 Sample4 ... (8 Replies)
Discussion started by: Geneanalyst
8 Replies

LEARN ABOUT PHP

tc-cgroup

Cgroup classifier in tc(8)					       Linux						Cgroup classifier in tc(8)

NAME

       cgroup - control group based traffic control filter

SYNOPSIS

       tc filter ... cgroup [ match EMATCH_TREE ] [ action ACTION_SPEC ]

DESCRIPTION

       This  filter  serves as a hint to tc that the assigned class ID of the net_cls control group the process the packet originates from belongs
       to should be used for classification. Obviously, it is useful for locally generated packets only.

OPTIONS

       action ACTION_SPEC
	      Apply an action from the generic actions framework on matching packets.

       match EMATCH_TREE
	      Match packets using the extended match infrastructure. See tc-ematch(8)  for  a  detailed  description  of  the  allowed	syntax	in
	      EMATCH_TREE.

EXAMPLES

       In order to use this filter, a net_cls control group has to be created first and class as well as process ID(s) assigned to it. The follow-
       ing creates a net_cls cgroup named "foobar":

	      modprobe cls_cgroup
	      mkdir /sys/fs/cgroup/net_cls
	      mount -t cgroup -onet_cls net_cls /sys/fs/cgroup/net_cls
	      mkdir /sys/fs/cgroup/net_cls/foobar

       To assign a class ID to the created cgroup, a file named net_cls.classid has to be created which contains the class ID to be assigned as  a
       hexadecimal,  64bit  wide  number.  The upper 32bits are reserved for the major handle, the remaining hold the minor. So a class ID of e.g.
       ff:be has to be written like so: 0xff00be (leading zeroes may be omitted). To continue the above example, the following	assigns  class	ID
       1:2 to foobar cgroup:

	      echo 0x10002 > /sys/fs/cgroup/net_cls/foobar/net_cls.classid

       Finally some PIDs can be assigned to the given cgroup:

	      echo 1234 > /sys/fs/cgroup/net_cls/foobar/tasks
	      echo 5678 > /sys/fs/cgroup/net_cls/foobar/tasks

       Now by simply attaching a cgroup filter to a qdisc makes packets from PIDs 1234 and 5678 be pushed into class 1:2.

SEE ALSO

       tc(8), tc-ematch(8),
       the file Documentation/cgroups/net_cls.txt of the Linux kernel tree

iproute2							    21 Oct 2015 					Cgroup classifier in tc(8)
All times are GMT -4. The time now is 04:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy