Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk summing specific lines and fields
Top Forums Shell Programming and Scripting awk summing specific lines and fields Post 302725177 by ctsgnb on Thursday 1st of November 2012 07:30:46 PM
Old 11-01-2012
@vgersh99
You need to add a conversion step (GB, MB, KB ...) as well as to remove superfluous comas since the dot stand for decimal separator.

Code:
awk -F";" 'tolower($0)!~/parent: line/{k=1024;m=k*k;g=k*m;for(i=10;i<=14;i++) {gsub(",",z,$i);split($i,a," ");s+=a[1]*(a[2]=="GB"?g:a[2]=="MB"?m:a[2]=="KB"?k:1)} print $0 FS "sum=" s/m "[MB]="s/g "[GB]"}' OFS=";" yourfile

Idented properly :

Code:
awk -F";" 'tolower($0)!~/parent: line/{
k=1024;m=k*k;g=k*m;
for(i=10;i<=14;i++) {
        gsub(",",z,$i);split($i,a," ")
        s+=a[1]*(a[2]=="GB"?g:a[2]=="MB"?m:a[2]=="KB"?k:1)
    }
print $0 FS "sum=" s/m "[MB]="s/g "[GB]"
}' OFS=";" yourfile

Last edited by ctsgnb; 11-01-2012 at 09:15 PM..
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

summing up the fields in fixed width file

Hi, I have a fixed width file with some records as given below: " 1000Nalsdjflj243324jljlj" "-0300Njfowjljl309933fsf" " 0010Njsfsjklj342344fsl" I want to sum-up first field values(i.e from 2nd character to 6th character)of each record. so for the above file i want to add (1000 - 300+... (2 Replies)
Discussion started by: srilaxmi
2 Replies

2. UNIX for Dummies Questions & Answers

Updating specific fields with awk using conditions

Can someone help me again, I think with awk? I have a file with 4 columns (pipe-delimited): I just want to convert the last field so that e1 is now 'message 1', e2 is 'message 2', e0 is 'message 3', etc. I don't want to change any other columns because the e0-e10 code may appear as part of a... (4 Replies)
Discussion started by: giannicello
4 Replies

3. Shell Programming and Scripting

Summing over specific lines and replacing the lines with the sum using sed, awk

Hi friends, This is sed & awk type question. I have a text file which has numbers spread all over the file. I want to sum the series of numbers whenever i find it and produce an output file with the sum. For example ###start of input text file #### abc def ghi 1 2 3 4 kjld random... (3 Replies)
Discussion started by: kaaliakahn
3 Replies

4. Shell Programming and Scripting

Summing over specific lines and replacing the lines with the sum

Hi friends, This is sed & awk type question. It is slightly different from my previous question. I have a text file which has numbers spread all over the file. I want to sum the series of numbers (but no more than 10 numbers in series) whenever i find it and produce an output file with the... (4 Replies)
Discussion started by: kaaliakahn
4 Replies

5. Shell Programming and Scripting

Summing all fields in a file

I was playing around to see how stuff works, and was trying to sum all fields in a file. cat file 1 2 3 4 5 6 7 8 9 10 11 12 I made this script: awk 'BEGIN {OFS=RS}{$1=$1}{s+=$0} END {print "sum="s}' file This gives 15, why not 78? I test it like this awk 'BEGIN... (5 Replies)
Discussion started by: Jotne
5 Replies

6. UNIX for Dummies Questions & Answers

Read the file and generate specific fields by awk

Hi I need to generate these output file from the below input file. Output : customer_id as customer, zip as zip_cd, catg_cd as catg, Input: out.customer::in.customer_id; out.zip_cd::in.zip; out.catg::in.catg_cd; Could you please help me on this. Please use code tags next... (1 Reply)
Discussion started by: Murugesh
1 Replies

7. Shell Programming and Scripting

Getting max value of specific fields with awk

Hello All, Here is am trying to get maximum value of third field depending on first,second and fourth fields with awk command . delimeter is pipe(|) . input 0221|09|14.25|aaa 0221|09|44.27|aaa 0221|09|44.33|aaa 0221|09|44.53|bbb 0221|09|34.32|bbb 0221|09|37.13|bbb... (5 Replies)
Discussion started by: sayami00
5 Replies

8. Shell Programming and Scripting

awk to combine lines if fields match in lines

In the awk below, what I am attempting to do is check each line in the tab-delimeted input, which has ~20 lines in it, for a keyword SVTYPE=Fusion. If the keyword is found I am splitting $3 using the . (dot) and reading the portion before and after the dot in an array a. If it does have that... (12 Replies)
Discussion started by: cmccabe
12 Replies

9. UNIX for Beginners Questions & Answers

Grep or awk a unique and specific word across many fields

Hi there, I have data with similar structure as this: CHR START-SNP END-SNP REF ALT PATIENT1 PATIENT2 PATIENT3 PATIENT4 chr1 69511 69511 A G homo hetero homo hetero chr2 69513 69513 T C . hetero homo hetero chr3 69814 69814 G C . . homo homo chr4 69815 69815 C A hetero . . hetero is... (10 Replies)
Discussion started by: daashti
10 Replies

LEARN ABOUT FREEBSD

kiconv_add_xlat16_cspairs

KICONV(3)						   BSD Library Functions Manual 						 KICONV(3)

NAME

     kiconv_add_xlat16_cspair, kiconv_add_xlat16_cspairs, kiconv_add_xlat16_table -- kernel side iconv library

LIBRARY

     Kernel side iconv library (libkiconv, -lkiconv)

SYNOPSIS

     #include <sys/iconv.h>

     int
     kiconv_add_xlat16_cspair(const char *tocode, const char *fromcode, int flag);

     int
     kiconv_add_xlat16_cspairs(const char *foreigncode, const char *localcode);

     int
     kiconv_add_xlat16_table(const char *tocode, const char *fromcode, const void *data, int datalen);

DESCRIPTION

     The kiconv library provides multi-byte character conversion tables for kernel side iconv service.

     The kiconv_add_xlat16_cspair() function defines a conversion table using iconv(3) between fromcode charset and tocode charset.  You can spec-
     ify flag to determine if tolower(3) / toupper(3) conversion is included in the table.  The flag has following values.

     KICONV_LOWER
     KICONV_FROM_LOWER	It generates a tolower table in addition to a character conversion table.  The difference between two is tolower tocode or
			tolower fromcode.
     KICONV_UPPER
     KICONV_FROM_UPPER	It generates a toupper table in addition to a character conversion table.  The difference between two is toupper tocode or
			toupper fromcode.

     A tolower/toupper conversion is limited to single-byte characters.

     The kiconv_add_xlat16_cspairs() function defines two conversion tables which are from localcode to foreigncode and from foreigncode to
     localcode.  These conversion tables also contain both tolower and toupper tables.

     The kiconv_add_xlat16_table() function defines a conversion table directly pointed by data whose length is datalen, not using iconv(3).

SEE ALSO

     iconv(3), tolower(3), toupper(3)

BSD
								   July 17, 2003							       BSD
All times are GMT -4. The time now is 08:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy