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 :
*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:
Could you please help if i missed anything in my query.
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 Replies)
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 ... (2 Replies)
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... (10 Replies)
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... (5 Replies)
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... (3 Replies)
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... (1 Reply)
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... (12 Replies)
Discussion started by: as7951
12 Replies
LEARN ABOUT DEBIAN
gst-convert
GST-CONVERT(1) User Commands GST-CONVERT(1)NAME
gst-convert - Smalltalk syntax converter and beautifier
DESCRIPTION
Usage:
gst-convert [OPTION]... [INFILE [OUTFILE]] gst-convert [OPTION]... -o|--output OUTFILE INFILES
OPTIONS -q, --quiet
don't show any message
-v, --verbose
print extra information while processing
-f, --format=FORMAT
convert from given input format (supported formats are gst, gst2, sif, squeak)
-F, --output-format=FORMAT convert to given output format (supported
formats are gst, gst2, squeak)
-C, --class=REGEX
convert only classes matching REGEX
-C, --class=+REGEX
in addition, convert classes matching REGEX
-C, --class=-REGEX
do not convert classes matching REGEX
-c, --category=REGEX
convert only classes whose category matches REGEX
-c, --category=+REGEX
in addition, convert those whose category matches REGEX
-c, --category=-REGEX
do not convert classes whose category matches REGEX
-r, --rule='CODE->REPL'
look for CODE and replace it with REPL
-o, --output OUTFILE
concatenate multiple input files into a single converted output file
--help display this message and exit
--version
print version information and exit
SEE ALSO
The full documentation for gst-convert is maintained as a Texinfo manual. If the info and gst-convert programs are properly installed at
your site, the command
info gst
should give you access to the complete manual.
gst-convert version 3.2.4 December 2011 GST-CONVERT(1)