Your desired output cannot be calculated from your input sample, as none of the "KPNA7_9" lines has a $7 greater than or equal 20.
Your first awk script prints two fields per line, so a $5 or $7 as referenced in the second will be nil.The only element printed is count[""] which is 3 .
In your third awk script, ALL lines on stdin will be operated upon by the first action, and then next will ignore the rest of the script. Nothing will ever be printed.
A decent, consistent structuring like indenting and block building, etc. - your choice, but stick to it - of the program(s) will help you (later) and others reading and understanding your logics.
Hi I'm new to this forum and I'm a beginner when it comes to shell and awk programming. But I have the following problem:
I have 5 csv files (data1.csv, data2.csv, etc.) and need to calculate the average between the total sum of the 1st and 7 column.
csv example:... (3 Replies)
hi everyone,
# cat a
a 10%
b 25.5%
c 91%
d 50%
# cat a | awk '$2 >= 90%; END {print $_}'
awk: $2 > 90%; END {print $_}
awk: ^ syntax error
awk: each rule must have a pattern or an action part
how to do only print when 2nd coln >= 90%.
Thanks (6 Replies)
My item was not answered on previous thread as code given did not work
I wanted to print records from file2 where comparing column 1 and 16 for both files find rows where column 16 in file 1 does not match column 16 in file 2
Here was CODE give to issue
~/unix.com$ cat f1... (0 Replies)
Hi All,
Thanks all for the continued support so far.
Today, I need to find the most occurring string/number(also called mode in statistics terminology) for each column in a data file (.csv type).
For one column of data(1.txt) like below
Sample
1
2
2
3
4
1
1
1
2
I can find the mode... (6 Replies)
Hi,
I need some help on how to print the whole data for unmatched pattern. i have 2 different files that need to be checked and print out the unmatched patterns into a new file. My sample data as follows:-
File1.txt
Id Num Activity Class Type
309 1.1 ... (5 Replies)
In the file below I am trying to extract a specific instance of path, if the adjacent plugin": "/rundb/api/v1/plugin/49/. Thank you :).
file
"path": "/results/analysis/output/Home/Auto_user_S5-00580-4-Medexome_65_028/plugin_out/FileExporter_out.52", "plugin": "/rundb/api/v1/plugin/49/",... (8 Replies)
Trying to use awk to print the lines in file that have either REF or SNV in $3, add a header line, sort by $4 in numerical order. The below code does that already, but where I am stuck is on the last part where the total lines are counted and printed under Total_Targets, under Targets_less_than is... (4 Replies)
I am starting to write a multi-line awk and using the file below which is
tab-delimited, print only the line with oncomineGeneClass
and oncomineVariantClass and PASS. The script execute but
seems to be printing the entire file, not the desired line. Thank you :).
file
... (8 Replies)
Hi Folks,
I have one requirement, There is one file, which contains two fields.
Based on first field, I need to print an output.
Example will be more suitable.
Input file like this.
abc 5
abc 10
xyz 6
xyz 9
xyz 10
mnp 10
mnp 12
mnp 6 (2 Replies)