|
|
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 303043629 by Scrutinizer on Sunday 2nd of February 2020 02:23:36 PM
|
|
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 DEBIAN
ample.html
AMPLE.HTML(5) User Manual AMPLE.HTML(5) NAME
ample.html - html template for Ample DESCRIPTION
This file, by default /etc/ample/ample.html, is read by Ample at startup and used as a base for it's HTML pages. These pages are rendered whenever a webbrowser connects and requests a list of available songs and directories (typically done by connecting to http://server:port/index.html). The file is divided into three sections, the header, the middle and the footer. The header and the footer are the same on each page gener- ated while the "middle" is copied into the final HTML document once for each file or directory that is going to be listed. Although this may sound confusing, it will probably become much more evident once you look at the example below. Variables are written in uppercase and enclosed within "at" signs (example: @NAME@) and are replaced dynamically when the page is con- structed. Some variables can exist anywhere in the document and some can only exist in the "middle" section, see the information about each variable for details. EXAMPLE
<!-- Beginning of header --> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html><head> <title>@SERVERNAME@</title> </head><body> <center> <p><h1>@SERVERNAME@</h1></p> <p><h2>Tracks currently available in @PATH@</h2></p> <p><font size="-1">[ <a href="index.m3u">playlist for this dir</a> | <a href="rindex.m3u">recursive playlist</a> ] </font></p> <p><font size="-1"> [ <a href="../index.html">Up one level</a> ] </font></p> <div align="center"> <table border="1" cellspacing="0" cellpadding="0" bordercolor="#000000"> <tr><td> <b>TYPE</b> </td><td> <b>URL</b> </td></tr> <!-- End of header --> @BEGIN@ <!-- Beginning of "middle" --> <tr><td> @TYPE@ </td><td> <a href="@URL@">@NAME@</a> </td></tr> <!-- End of "middle" --> @END@ <!-- Beginning of footer --> </table> </div> <p align="right"><font size="-1"> powered by Ample, for more information, see the <a href="http://ample.sourceforge.net">project homepage</a> </font></p> </center> </body> </html> <!-- End of footer --> SUMMARY OF VARIABLES
SPECIAL - Only used once BEGIN END GLOBAL - Can be used anywhere SERVERNAME PORT PATH NON-GLOBAL - Can only be used in the "middle" section NAME URL LENGTH TITLE SIZE TYPE SPECIAL VARIABLES
These can only be used once. BEGIN This variable (when placed in the beginning of a new line) marks the end of the header section and the start of the "middle" sec- tion. END This variable (when placed in the beginning of a new line) marks the end of the "middle" section and the start of the footer sec- tion. GLOBAL VARIABLES
These can be used anywhere. SERVERNAME The name of the server as given in ample.conf(5). PORT The port that the server is listening to. PATH The current path the user is viewing. NON-GLOBAL VARIABLES These can only be used in the "middle" section. NAME The name of the song or directory. URL The URL of the song or directory. LENGTH The song length (in seconds) or blank if it is a directory. TITLE The title of the song or "DIR" if it is a directory. SIZE The file size or blank if it is a directory. TYPE "FILE" if it is a file or "DIR" if it is a directory. AUTHOR
David Hardeman <david@2gen.com> SEE ALSO
ample(1), ample.conf(5) Ample JANUARY 2002 AMPLE.HTML(5)