Sum fields of different files using awk Post: 302836047

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sort sum fields

HI ALL, i have a problem when i do a sort sum with many fields. Is there a limit for fields? Do you know a solution? thanks in advance. the shell is: # SORT1 SORT1_rcode=777 if ; then echo "USE $DARSEQ/OTPU.FTPEPREC RECORD F,1000 " > $DARPARSRT/TPEKL508.SORT1_$$.srt ...

2. Shell Programming and Scripting

calculating sum of fields in a file

Hey, I have a file and it has only one field. I need to calculate the sum of each filed as total. For e.g my file is 1 2 3 4 5 I need to calculate the total sum as 15. Please let me know how i can do it?

3. Shell Programming and Scripting

Compare fields in 2 files using AWK

Hi unix gurus, I have a urgent requirement, I need to write a AWK script to compare each fields in 2 files using AWK. Basically my output should be like this. file1 row|num1|num2|num3 1|one|two|three 2|one|two|three file2 row|num1|num2|num3 1|one|two|three 2|one|two|four ...

4. Programming

comparing two fields from two different files in AWK

Hi, I have two files formatted as following: File 1: (user_num_ID , realID) (the NR here is 41671) 1 cust_034_60 2 cust_80_91 3 cust_406_4 .. .. File 2: (realID , clusterNumber) (total NR here is 1000) cust_034_60 2 cust_406_4 3 .. ..

5. Shell Programming and Scripting

To perform sum aggregation on numeric fields

Hi all, I have following scenario to perform sum aggregation on certain columns Node Allocated_Space Pool_Name CS_Group Utilized Space -------- ---------------- ---------- --------- -------------- bdw1a_lun01 300 bdw_p0 ...

6. Shell Programming and Scripting

Need help in finding sum for values in 2 different fields

Hi there, I have 2 files in following format cat file_1 Storage Group Name: aaaa HBA UID SP Name SPPort ------- ------- ------ 0 21 Storage Group Name: bbbb HBA UID...

7. Shell Programming and Scripting

Need to sum up a column value from multiple files into Credit and Debit categories using awk command

i have multiple files with Batch Header, Record detail & Batch trailer data in the files like : BH 20150225950050N8262 RD 20140918000000 99999999 unk Deferred Settlement -13950 BT01 -13950 *Above sample data donot have the spaces coorectly defined. I do have multiple batch trailer...

8. Shell Programming and Scripting

awk to comppare two files using rwo fields

I use the two awk scripts for comparing file1 and file2. First awk compare $3 column: awk -v OFS="\t" 'NR==FNR{a=$4;next}{$2=$2 "\t"(a?a:"-")}1' file1 file2Second awk compare $2 column: awk -v OFS="\t" 'NR==FNR{a=$4;next}{$2=$2 "\t"(a?a:"-")}1' file1 file2 The only difference ...

9. Shell Programming and Scripting

awk to update file with sum of matching fields in another file

In the awk below I am trying to add a penalty to a score to each matching $1 in file2 based on the sum of $3+$4 (variable TL) from file1. Then the $4 value in file1 is divided by TL and multiplied by 100 (this valvue is variable S). Finally, $2 in file2 - S gives the updated $2 result in file2....

10. UNIX for Beginners Questions & Answers

awk match two fields in two files

Hi, I have two TEST files t.xyz and a.xyz which have three columns each. a.xyz have more rows than t.xyz. I will like to output rows at which $1 and $2 of t.xyz match $1 and $2 of a.xyz. Total number of output rows should be equal to that of t.xyz. It works fine, but when I apply it to large...

LEARN ABOUT REDHAT

clangb

CLANGB(l)								 )								 CLANGB(l)

NAME

       CLANGB - return the value of the one norm, or the Frobenius norm, or the infinity norm, or the element of largest absolute value of an n by
       n band matrix A, with kl sub-diagonals and ku super-diagonals

SYNOPSIS

       REAL FUNCTION CLANGB( NORM, N, KL, KU, AB, LDAB, WORK )

	   CHARACTER NORM

	   INTEGER   KL, KU, LDAB, N

	   REAL      WORK( * )

	   COMPLEX   AB( LDAB, * )

PURPOSE

       CLANGB returns the value of the one norm, or the Frobenius norm, or the infinity norm, or the element of largest absolute value of an n	by
       n band matrix A, with kl sub-diagonals and ku super-diagonals.

DESCRIPTION

       CLANGB returns the value

	  CLANGB = ( max(abs(A(i,j))), NORM = 'M' or 'm'
		   (
		   ( norm1(A),	       NORM = '1', 'O' or 'o'
		   (
		   ( normI(A),	       NORM = 'I' or 'i'
		   (
		   ( normF(A),	       NORM = 'F', 'f', 'E' or 'e'

       where  norm1  denotes the  one norm of a matrix (maximum column sum), normI  denotes the  infinity norm	of a matrix  (maximum row sum) and
       normF  denotes the  Frobenius norm of a matrix (square root of sum of squares).	Note that  max(abs(A(i,j)))  is not a  matrix norm.

ARGUMENTS

       NORM    (input) CHARACTER*1
	       Specifies the value to be returned in CLANGB as described above.

       N       (input) INTEGER
	       The order of the matrix A.  N >= 0.  When N = 0, CLANGB is set to zero.

       KL      (input) INTEGER
	       The number of sub-diagonals of the matrix A.  KL >= 0.

       KU      (input) INTEGER
	       The number of super-diagonals of the matrix A.  KU >= 0.

       AB      (input) COMPLEX array, dimension (LDAB,N)
	       The band matrix A, stored in rows 1 to KL+KU+1.	The j-th column of A is stored in the j-th column of  the  array  AB  as  follows:
	       AB(ku+1+i-j,j) = A(i,j) for max(1,j-ku)<=i<=min(n,j+kl).

       LDAB    (input) INTEGER
	       The leading dimension of the array AB.  LDAB >= KL+KU+1.

       WORK    (workspace) REAL array, dimension (LWORK),
	       where LWORK >= N when NORM = 'I'; otherwise, WORK is not referenced.

LAPACK version 3.0						   15 June 2000 							 CLANGB(l)