|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
awk to sum specific field when pattern matches
Post 302454594 by rdcwayx on Sunday 19th of September 2010 02:55:30 AM
09-19-2010
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i have an awk statement which i am using to count the number of occurences of the number ,5, in the file:
awk '/,5,/ {count++}' TRY.txt | awk 'END { printf(" Total parts: %d",count)}'
i know there is a total of 10 matches..what is wrong here?
thanks (16 Replies)
Discussion started by: npatwardhan
16 Replies
2. Shell Programming and Scripting
Hi All,
I would like my code to be able to print out the whole line if 1st field has a dot in the number. Sample input and expected output given below.
My AWK code is below but it can;t work, can any expert help me ?
Thanks in advance.
{if ($1 ~ /*\.*/) { print $0 }}
Input:
... (2 Replies)
Discussion started by: Raynon
2 Replies
3. Shell Programming and Scripting
Howdy.
I know this is most likely possible using sed or awk or grep, most likely a combination of them together, but how would one go about running a grep like command on a file where you only try to match your pattern to the second field in a line, space delimited?
Example:
You are... (3 Replies)
Discussion started by: LordJezoX
3 Replies
4. Shell Programming and Scripting
Hi,
I have requirement that I need to split my input file into two files based on a search pattern "abc"
For eg. my input file has below content
abc
defgh
zyx
I need file 1 with
abc
and file2 with
defgh
zyx
I can use grep command to acheive this. But with grep I need... (8 Replies)
Discussion started by: sbhuvana20
8 Replies
5. Shell Programming and Scripting
Hi,
I am trying with the below Perl command to print the first field when the second field matches the given pattern:
perl -lane 'open F, "< myfile"; for $i (<F>) {chomp $i; if ($F =~ /patt$/) {my $f = (split(" ", $i)); print "$f";}} close F' dummy_file
I know I can achieve the same with the... (7 Replies)
Discussion started by: royalibrahim
7 Replies
6. Shell Programming and Scripting
Hi
Am trying to sum up a file
# cat /Out
maths 2 0.0
english 2091 0.2
history -1 0.0
physics 18 0.0
--------------------------------------
maths ... (9 Replies)
Discussion started by: Priya Amaresh
9 Replies
7. Shell Programming and Scripting
To match range, the command is:
awk '/BEGIN/,/END/'
but what I want is the range is printed only if there is additional pattern that matches in the range itself? maybe like this:
awk '/BEGIN/,/END/ if only in that range there is /pattern/'
Thanks (8 Replies)
Discussion started by: zorrox
8 Replies
8. Shell Programming and Scripting
Using the attached file, the below awk command results in the output below:
I can not seem to produce the desired results and need some expert help. Thank you :).
awk -F'' '
{
id += $4
value += $5
occur++
}
END{
printf "%-8s%8s%8s%8s\n", "Gene", "Targets", "Average Depth", "Average... (3 Replies)
Discussion started by: cmccabe
3 Replies
9. Shell Programming and Scripting
I am trying to remove lines in the target.txt file if $5 before the - in that file matches sorted_list. I have tried grep and awk. Thank you :).
grep
grep -v -F -f targets.bed sort_list
grep -vFf sort_list targets
awk
awk -F, '
> FILENAME == ARGV {to_remove=1; next}
> ! ($5 in... (2 Replies)
Discussion started by: cmccabe
2 Replies
10. Shell Programming and Scripting
Trying to output a result that uses the data from file to combine and subtract specific lines. If $4 matches in each line then the last $6 value is added to $2 and that becomes the new$3. Each matching line in combined into one with $1 then the original $2 then the new$3 then $5. For the cases... (4 Replies)
Discussion started by: cmccabe
4 Replies
LEARN ABOUT DEBIAN
plucene::search::termquery
Plucene::Search::TermQuery(3pm) User Contributed Perl Documentation Plucene::Search::TermQuery(3pm) NAME
Plucene::Search::TermQuery - a query that contains a term SYNOPSIS
# isa Plucene::Search::Query $term_query->normalize($norm); my $ssw = $term_query->sum_squared_weights($searcher); my $as_string = $term_query->as_string($field); DESCRIPTION
A query that matches a document containing a term. Term query are the simplest possible Plucene queries and are used to match a single word. Term queries are represented by instances of the TermQuery class and contain the desired term (word) and a field name, both are case sensitive. The field specified in a Term query must be a document field that was specified as 'indexible' during the indexing process. If the field was specified during indexing as 'tokenized' than the term will be matched against each of tokens (words) found in that field, otherwise, it will be matched against the entire content of that field. A term query may have an optional boost factor (default = 1.0) that allows to increase or decrease the ranking of documents it matches. METHODS
term / idf / weight Get / set these attributes sum_squared_weights my $ssw = $term_query->sum_squared_weights($searcher); This will return the sum squared weights for the passed in searcher. normalize $term_query->normalize($norm); to_string my $as_string = $term_query->as_string($field); perl v5.12.4 2011-08-14 Plucene::Search::TermQuery(3pm)