Group/concatenate certain column and basis on this do addition on other column
Hi Experts,
Need your support
I want to group/concatenate column 1,2,12 and 13 and if found duplicate then need to sum value of column 17,20,21 and column22. After concatenation if found unique then no action to be taken.
Secondly want to make duplicate rows basis on grouping/concatenation of column 1,2,12 and 13 as single rows in outputfile and those single rows should have column sum (of column 17,20,21 and column22 from input file)
Input file :
Sample Expected output
Code : i have tried
Code output : Not correct because is column1 value "27AAACH1458C1ZZ|042018" is repeating twice and also sum of these rows are not correct. Same problem is with others column 1 values like "09AAACT2438A1ZR"
I have a file in the following format. Groups of data merge together and the group number is indicated above each group.
1
adrf
dfgr
dfg
2
dfgr
dfgr
3
dfef
dfr
fd
4
fgrt
fgr
fgg
5
fgrt
fgr (3 Replies)
Good day,
First off, I would just like to say that I've been helped by a lot of the posts here in my own scripting work in the past few months. I've been a long time roamer, but first time poster. That being said, I'm stuck trying to figure out this issue (For computational research, not a... (4 Replies)
file A
aa 22 48
ab 22 48
tcf 50 76
gf 50 76
h 89 100
yh 89 100
how can we split the file on the basis of common 2 and third column
output like
file A-1
aa 22 48
ab 22 48
file A-2
cf 50 76
gf 50 76 (3 Replies)
Hi All,
i need ti delete two duplicate processss which are running on the same device type (column 1) and port ID (column 2). here is the sample data
p1sc1m1 15517 11325 0 01:00:24 ? 0:00 scagntclsx25octtcp 2967 in3v mvmp01 0 8000 N S 969 750@751@752@
p1sc1m1 15519 11325 0 01:00:24 ? ... (5 Replies)
Hi,
I am new to linux...
I have a file which looks like:
I want to print the entire row in which 5th column is having minimum value for every first column (i.e min for 9 and min for 16). Along with the condition awk -F" " 'b < $5 {b=$5; a=$0} END {for (i in a) {print a}}' inputfile >... (1 Reply)
Hi,
I am new to linux...
I have a file which looks like:
I want to print the entire row in which 5th column is having minimum value for every first column (i.e min for 9 and min for 16). Along with the condition awk -F" " 'b < $5 {b=$5; a=$0} END {for (i in a) {print a}}' inputfile >... (5 Replies)
Here is my problem:-
I have a file with pipe separated values.
CR|20121021|079|ABC|N|DLS|00038|DLS|04750|1330597704|634234|634|0
CR|20121021|079|ABC|N|DLS|00038|DLS|05118|2071690102|354|351|3
CR|20121021|079|ABC|N|DLS|00038|DLS|05140|960051505|1088|1088|0... (4 Replies)
Hi,
Can you please help in resolving below issue:
I have input file as below.
COL1 COL2
ABC 111asdf
ABC 222dfgh
ABC 333fghy
ABC 4rtyu
XYZ 1yuio
XYZ 2ytre
Lookg for the Output File as below
COL1 COL2
ABC '111asdf','222dfgh','333fghy','4rtyu'
XYZ ... (6 Replies)
I have a file (myfile.txt) with contents like this:
1.txt apple is
3.txt apple is
5.txt apple is
2.txt apple is a
7.txt apple is a
8.txt apple is a fruit
4.txt orange not a fruit
6.txt zero isThe above file is already sorted using this command:
sort -k2 myfile.txtMy objective is to get... (3 Replies)