Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Awk/sed summation of one column based on some entry in first column
Top Forums UNIX for Beginners Questions & Answers Awk/sed summation of one column based on some entry in first column Post 303041916 by RudiC on Saturday 7th of December 2019 05:57:42 AM
Old 12-07-2019
Try
Code:
tac file | awk -F" +" '{SUM += $4} $1 {$5 = SUM; SUM = 0} 1' | tac

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk/sed column replace using column header - help

$ cat log.txt Name Age Sex Lcation nfld alias xsd CC 25 M XYZ asx KK Y BB 21 F XAS awe SS N SD 21 M AQW rty SD A How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column? so that the final output will become: Name Age Sex... (10 Replies)
Discussion started by: jkl_jkl
10 Replies

2. Shell Programming and Scripting

Awk or Sed, fubd match in column, then edit column.

FILE A: 9780743551526,(Abridged) 9780743551779,(Unabridged) 9780743582469,(Abridged) 9780743582483,(Unabridged) 9780743563468,(Abridged) 9780743563475,(Unabridged) FILE B: c3saCandyland 9780743518321 "CANDYLAND" "MCBAIN, ED" 2001 c3sbCandyland 9780743518321 ... (7 Replies)
Discussion started by: glev2005
7 Replies

3. Shell Programming and Scripting

for each different entry in column 1 extract maximum values from column 2 in unix/awk

Hello, I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2 SDF4 -0.211654 SDF4 0.978068 ... (1 Reply)
Discussion started by: Diya123
1 Replies

4. Shell Programming and Scripting

Rename a header column by adding another column entry to the header column name URGENT!!

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies

5. Shell Programming and Scripting

awk or sed: change the color of a column w/o screwing up column spacing

Hey folks. I wrote a little awk script that summarizes /proc/net/dev info and then pipes it to the nix column command to set up column spacing appropriately. Here's some example output: Iface RxMBytes RxPackets RxErrs RxDrop TxMBytes TxPackets TxErrs TxDrop bond0 9 83830... (3 Replies)
Discussion started by: ryran
3 Replies

6. Shell Programming and Scripting

Pick the column value based on another column using awk or CUT

My scenario is that I need to pick value from third column based on fourth column value, if fourth column value is 1 then first value of third column.Third column (2|3|4|6|1) values are cancatenated. Please someone help me to resolve this issue. Source column1 column2 column3 column4... (2 Replies)
Discussion started by: Ganesh L
2 Replies

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

8. Shell Programming and Scripting

awk script to call another script based on second column entry

Hi I have a text file (Input.txt) with two column entries separated by tab as given below: aaa str1 bbb str2 cccccc str3 dddd str4 eee str3 ssss str2 sdf str3 hhh str1 fff str2 ccc str3 ..... ..... ..... (1 Reply)
Discussion started by: my_Perl
1 Replies

9. Shell Programming and Scripting

Solution for replacement of 4th column with 3rd column in a file using awk/sed preserving delimters

input "A","B","C,D","E","F" "S","T","U,V","W","X" "AA","BB","CC,DD","EEEE","FFF" required output: "A","B","C,D","C,D","F" "S", T","U,V","U,V","X" "AA","BB","CC,DD","CC,DD","FFF" tried using awk but double quotes not preserving for every field. any help to solve this is much... (5 Replies)
Discussion started by: khblts
5 Replies

10. Shell Programming and Scripting

sed command to add a new column entry

My input file looks like this 12 3 5.122.281.413 172.31.15.220 3421 4133 2 2 1454 3421 4133 2 2 0 12 44036 214.215.52.146 90.123.245.211 2312 3911 4 4 521 2312 3911 4 4 1 14 504 6.254.324.219 192.61.27.120 4444 5611 7 5 1415 4444 5611 7 5 1 ... (2 Replies)
Discussion started by: sampitosh
2 Replies

LEARN ABOUT OPENSOLARIS

mlib_signalconv_f32_f32

mlib_SignalConv_S16_S16_Sat(3MLIB)			    mediaLib Library Functions				mlib_SignalConv_S16_S16_Sat(3MLIB)

NAME

       mlib_SignalConv_S16_S16_Sat, mlib_SignalConv_S16S_S16S_Sat, mlib_SignalConv_F32_F32, mlib_SignalConv_F32S_F32S - signal convolution

SYNOPSIS

       cc [ flag... ] file... -lmlib [ library... ]
       #include <mlib.h>

       mlib_status mlib_SignalConv_S16_S16_Sat(mlib_s16 *dst,
	    const mlib_s16 *src1, const mlib_s16 *src2, mlib_s32 m,
	    mlib_s32 n);

       mlib_status mlib_SignalConv_S16S_S16S_Sat(mlib_s16 *dst,
	    const mlib_s16 *src1, const mlib_s16 *src2, mlib_s32 m,
	    mlib_s32 n);

       mlib_status mlib_SignalConv_F32_F32(mlib_f32 *dst,
	    const mlib_f32 *src1, const mlib_f32 *src2, mlib_s32 m,
	    mlib_s32 n);

       mlib_status mlib_SignalConv_F32S_F32S(mlib_f32 *dst,
	    const mlib_f32 *src1, const mlib_f32 *src2, mlib_s32 m,
	    mlib_s32 n);

DESCRIPTION

       Each of these functions performs convolution.

       For monaural signals, the following equation is used:

		  m-1
	 dst[i] = SUM (src1[j] * src2[i - j])  if m <= n
		  j=0

		  n-1
	 dst[i] = SUM (src2[j] * src1[i - j])  if m > n
		  j=0

       where i = 0, 1, ..., (m + n - 2).

       For stereo signals, the following equation is used:

			m-1
	 dst[2*i]     = SUM (src1[2*j] * src2[2*(i - j)])
			j=0

			m-1
	 dst[2*i + 1] = SUM (src1[2*j + 1] * src2[2*(i - j) + 1])
			j=0

       if m <= n, or

			n-1
	 dst[2*i]     = SUM (src2[2*j] * src1[2*(i - j)])
			j=0

			n-1
	 dst[2*i + 1] = SUM (src2[2*j + 1] * src1[2*(i - j) + 1])
			j=0

       if m > n; where i = 0, 1, ..., (m + n - 2).

PARAMETERS

       Each of the functions takes the following arguments:

       dst     Destination signal array.

       src1    First source signal array.

       src2    Second source signal array.

       m       Number of samples in the first source signal array.

       n       Number of samples in the second source signal arrays.

RETURN VALUES

       Each of the functions returns MLIB_SUCCESS if successful. Otherwise it returns MLIB_FAILURE.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Committed 		   |
       +-----------------------------+-----------------------------+
       |MT-Level		     |MT-Safe			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       attributes(5)

SunOS 5.11							    2 Mar 2007					mlib_SignalConv_S16_S16_Sat(3MLIB)
All times are GMT -4. The time now is 10:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy