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

Sponsored Content

Top Forums Shell Programming and Scripting Need to sum up a column value from multiple files into Credit and Debit categories using awk command Post 302937327 by kcdg859 on Thursday 5th of March 2015 04:44:27 AM

03-05-2015

Registered User

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 :

Code:

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 records in 1 file.*

Batch trailer holds the sum of data from all RD type records.(3 columns for Batch Trailer with 2,10,18 as column widths.)
I need to calculate the Sum of data in Batch Trailer from all files in Debit & CRedit category.
I tried below queries, but i donot get any output:

Code:

awk '{$1=='BT' && value=SUBSTR($1,13,30); if(value>0) {credit+=value}} END {print credit}' FIELDWIDTHS="2 10 18" AMT92015-02-25
 
awk ' {$0=='BT' &&
value=substr($0,13,30)
if(value>0) { plus+=value}
else {minus+=value}
}
END { print plus, minus} ' AMT*

Could you please help if i missed anything in my query.

kcdg859

View Public Profile for kcdg859

Find all posts by kcdg859

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sum multiple columns based on column value

i have a file - it will be in sorted order on column 1 abc 0 1 abc 2 3 abc 3 5 def 1 7 def 0 1 -------- i'd like (awk maybe?) to get the results (any ideas)??? abc 5 9 def 1 8

2. Shell Programming and Scripting

Sum a column value based on multiple keys

Hi, I have below as i/p file: 5ABC 36488989 K 000010000ASB BYTRES 5PQR 45757754 K 000200005KPC HGTRET 5ABC 36488989 K 000045000ASB HGTRET 5GTH 36488989 K 000200200ASB BYTRES 5FTU ...

3. Shell Programming and Scripting

Join multiple files by column with awk

Hi all, I searched through the forum but i can't manage to find a solution. I need to join a set of files placed in a directory (~1600) by column, and obtain an output with first and second column common to each file, but following columns are taken from the file in the list (precisely the fourth...

4. Shell Programming and Scripting

How to sum multiple column output with awk ?

Hi Experts, I am trying to sum multiple columns and rows with awk , I want the sum of : 1] Horizontal Sum: (rows sum): 2] Vertical Sum: (Column's sum] details: # cat file1 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 40 31 32 33 34 35 36 37 38 39 70 41 42 43 44...

5. Shell Programming and Scripting

Sum of a column in multiple files

I am performing the following operation on a file that looks like this 1000 0 10 479.0 1115478.07497 0.0 0.0 0.0872665 1000 10 20 1500.0 3470012.29304 0.0 0.0 0.261799 1000 20 30 2442.0 5676346.87758 0.0 0.0 0.436332 1000 30 40 3378.0 7737905.30957 0.0 0.0 0.610865 1000 40 50 4131.0...

6. Shell Programming and Scripting

Awk: Multiple Replace In Column From Two Different Files

Master_1.txt 2372,MTS,AP 919821,Airtel,DL 0819,MTS,MUM 919849788001,Airtel,AP 1430,Aircel MP,20 405899143999999,MTS,KRL USSDLIKE,MTS,DEL Master_2.txt 919136,DL 9664,RAJ 919143,KOL 9888,PUN Input File:

7. Shell Programming and Scripting

awk to sum a column based on duplicate strings in another column and show split totals

Hi, I have a similar input format- A_1 2 B_0 4 A_1 1 B_2 5 A_4 1 and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks! letter number_of_letters...

8. Shell Programming and Scripting

Sum values of specific column in multiple files, considering ranges defined in another file

I have a file (let say file B) like this: File B: A1 3 5 A1 7 9 A2 2 5 A3 1 3 The first column defines a filename and the other two define a range in that specific file. In the same directory, I have also three more files (File A1, A2 and A3). Here is 10 sample lines...

9. Shell Programming and Scripting

awk to Sum columns when other column has duplicates and append one column value to another with Care

Hi Experts, Please bear with me, i need help I am learning AWk and stuck up in one issue. First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique. Second point : For...

10. Shell Programming and Scripting

Do replace operation and awk to sum multiple columns if another column has duplicate values

LEARN ABOUT DEBIAN

ptbatcher

PTBATCHER(1)							       HUGIN							      PTBATCHER(1)

NAME

       PTBatcher - CLI interface to Hugin Batch processor

SYNOPSIS

       PTBatcher [options] -a input.pto

DESCRIPTION

       PTBatcher Queues and processes stitching projects.  Functionality is similar to the the GUI Hugin Batch Processor.  The default action with
       the -a parameter is to add the specified project to the stitching queue and exit.

       The stitching queue may be processed by the GUI Hugin Batch Processor application, or by PTBatcher without a GUI, but not by both at the
       same time.  To process the queue with PTBatcher use the -b parameter.

OPTIONS

       -a file
	   add project to queue. Unless -o option is present, the default prefix is appointed.

       -o  output prefix (together with -a option)

       -l  list all projects in batch queue

       -c  clear all projects from batch queue

       -x id
	   remove project with specified id

       -r  reset all projects to waiting status

       -b  start batch process

       -p  use parallel processing (together with -b option)

       -d  delete .pto files when complete (together with -b option)

       -s  shutdown computer when complete (together with -b option)

       -v  verbose mode

       -h  print this help

SEE ALSO

       hugin(1) PTBatcherGUI(1)

AUTHORS

       Thomas Modes, Marko Kuder

"Version: 2011.4.0"						    2011-12-02							      PTBATCHER(1)