|
|
Sponsored Content
Top Forums
UNIX for Beginners Questions & Answers
Problem with getting awk to multiply a field by a value set based on condition of another field
Post 303043649 by RudiC on Monday 3rd of February 2020 03:03:01 AM
02-03-2020
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I want to find the top N entries for a certain field based on the values of another field.
For example if N=3, we want the 3 best values for each entry:
Entry1 ||| 100
Entry1 ||| 95
Entry1 ||| 30
Entry1 ||| 80
Entry1 ||| 50
Entry2 ||| 40
Entry2 ||| 20
Entry2 ||| 10
Entry2 ||| 50... (1 Reply)
Discussion started by: FrancoisCN
1 Replies
2. UNIX for Dummies Questions & Answers
So, I need to do some summing. I have an Apache log file with the following as a typical line:
127.0.0.1 - frank "GET /apache_pb.gif HTTP/1.0" 200 2326
Now, what I'd like to do is a per-minute sum. So, I can have awk tell me the individual minutes, preserving the dates(since this is a... (7 Replies)
Discussion started by: treesloth
7 Replies
3. Shell Programming and Scripting
Hi
i am new to scripting. i have a file file.dat with content as :
CONTENT_STORAGE PERCENTAGE FLAG:
/storage_01 64% 0
/storage_02 17% 1
I need to update the value of FLAG for a particular CONTENT_STORAGE value
I have written the following code
#!/bin/sh
threshold=20... (1 Reply)
Discussion started by: kichu
1 Replies
4. Shell Programming and Scripting
Hi everybody,
I'm trying to replace the $98 field with "T" if the last field (108th) is T
I've tried
awk 'BEGIN{OFS=FS="|"} {if ($108=="T")sub($98,"T"); print}' test.txt
but that doesn't do anything
also tried
awk 'BEGIN{OFS=FS="|"}{ /*T.$/ sub($98,"T")} { print}' test.txt
but... (2 Replies)
Discussion started by: jghi123
2 Replies
5. Shell Programming and Scripting
I am trying to confirm the counts from another code and tried the below awk, but the syntax is incorrect. Basically, outputting the counts of each condition in $8. Thank you :)
awk '$8==/TYPE=snp/ /TYPE=ins/ /TYPE=del/ {count++} END{print count}'... (6 Replies)
Discussion started by: cmccabe
6 Replies
6. Shell Programming and Scripting
In the tab-delimeted input file below I am trying to use awk to update the value in $2 if TYPE=ins in bold, by adding the value of
HRUN= in italics. In the below since in line 1 TYPE=ins the 117282541 value in $2 has 6 added because that is the value of HRUN=.
Hopefully the awk is a start but I... (2 Replies)
Discussion started by: cmccabe
2 Replies
7. Shell Programming and Scripting
I am trying to output a tab-delimited result that uses the data from a tab-delimited file to combine and subtract specific lines.
If $4 matches in each line then the first matching sequential $6 value is added to $2, unless the value is 1, then the original $2 is used (like in the case of line... (3 Replies)
Discussion started by: cmccabe
3 Replies
8. Shell Programming and Scripting
In the perl below, which does execute, I am having trouble with the else in Rule 3. The digit in f{8} is extracted and used to update f accordinly along with the value in f.
There can be either - * or + before the number that is extracted but the same logic applies, that is if the value is greater... (5 Replies)
Discussion started by: cmccabe
5 Replies
9. Shell Programming and Scripting
In the awk below I am trying to copy the entire contents of $6 there may be multiple values seperated by a ;, to $8, if $8 is . (lines 1 and 3 are examples). If that condition $8 is not . (line2 is an example) then that line is skipped and printed as is. The awk does execute but prints the output... (3 Replies)
Discussion started by: cmccabe
3 Replies
10. UNIX for Beginners Questions & Answers
Request your help to change the field color based on condition , if it is otherthan 0. using html in unix.
Here is my condition
for(i=1;i<=NF;i++)
{
print "<td> "$i"</td>
}
Please use CODE tags when displaying sample input, output, and code segments. (17 Replies)
Discussion started by: CatchMe
17 Replies
LEARN ABOUT NETBSD
makedbm
MAKEDBM(8) BSD System Manager's Manual MAKEDBM(8) NAME
makedbm -- create a NIS database SYNOPSIS
makedbm -u dbfile makedbm [-bls] [-d yp_domain_name] [-i yp_input_file] [-m yp_master_name] [-o yp_output_file] infile outfile DESCRIPTION
makedbm is the utility in NIS that creates the db(3) database file containing the NIS map. infile is the pathname of the source file (where ``-'' is standard input). Each line consists of the key and the value, with a space sepa- rating the items. Blank lines are ignored, and a ``#'' is a comment character and indicates that the rest of the line should be ignored. outfile is the pathname of the generated database. The options are as follows: -b Interdomain. Include an entry in the database informing a NIS server to use DNS to get information about unknown hosts. This option will only have effect on the maps hosts.byname and hosts.byaddr. -l Lowercase. Convert all keys to lower case before adding them to the NIS database. -s Secure map. Include an entry in the database informing ypxfr(8) and ypserv(8) that the NIS map is going to be handled as secure (i.e., not served to clients that don't connect from a reserved port). -d yp_domain_name Include an entry in the map with 'YP_DOMAIN_NAME' as the key and yp_domain_name as the value. -i yp_input_file Include an entry in the map with 'YP_INPUT_FILE' as the key and yp_input_file as the value. -m yp_master_name Include an entry in the map with 'YP_MASTER_NAME' as the key and yp_master_name as the value. -o yp_output_file Include an entry in the map with 'YP_OUTPUT_FILE' as the key and yp_output_file as the value. -u dbfile Dump the contents of dbfile to standard output, in a format suitable to be passed back into makedbm. dbfile is the pathname to the database. SEE ALSO
db(3), nis(8), ypserv(8), ypxfr(8) AUTHORS
Mats O Jansson <moj@stacken.kth.se> BSD
February 26, 2005 BSD