I wanted to know if there is a way to modify this awk statement to find out when column two switches directions. What i mean is the number in column two will get bigger then start to get smaller. When this happens I want to print out the value of column one.
I used this to find the maximum value:
I want to do something like this:
any ideas how to actually code/specify [1 Row above $2] and [1 Row below $2]?
If the input file is:
The output from the programme will be:
I think this is what you had in mind. It will handle floating point numbers as well, my simple test was just that: simple.
Niether of them worked; the problem was it seemed to pick random points not the peaks (I plotted them using GMT).
Instead of accepting defeat can I trouble you for a little explanation, if I understood the logic a little better I think I could tweak it. I am still new at awk but my professor loves it, and the more I use it the more I realize how powerful it actually is.
This is the part I don't quite understand. What exactly does NR == 1 accomplish? Your setting the number of rows equal to one? does a ';' seperate commands? So you set last equal to column 2, lost_row equal to column one.
Why do your run a getline? I looked it up and it is defined as:
getline - returns 1 if it finds a record, and 0 if the end of the file is encountered
Anyways I get the feeling that $1 and $2 are now rows above and below not columns?
This part logically makes sense, and this is what I am trying to accomplish.
Some special variables that AWK sets for each record (usually a line) that it reads:
NR = record number (by default the record separator, RS, is a newline, so NR is often the current line number). NR==1 {...} means to execute the commands in braces if this is the first record that AWK is processing.
NF = after field splitting, the number of fields (columns) in the current record.
$1 = the value of the first field
$2 = the value of the second field
$NF = the value of the last field.
Regards,
Alister
These 2 Users Gave Thanks to alister For This Post:
So that makes sense. I played around with it and have a data set that looks like:
if I:
I get 98. if I make NR == 2 i get 4.
So is there a way to check run an if statement with NR-1?
I want to compare the value directly above and below it?
I need to specify that location make sense? there is a numeric value one row above (NR-1) and in field 2 (which I abbreviated as [NR-1,$2] ) that I want to compare to the current row NR and field 2 (abbreviated $2).
Hi Guys,
I have this task to monitor a linux box. I found a program that displays the parameters that I want and I wrote a little .sh to run that program and record output into a file.
The findings look promising but I would like to graph them.
My output (for every iteration) looks like... (3 Replies)
Hello
I need to split big xml file into multiple files based on xml declaration. for that i have written one awk 1 liner as below
awk '/<?xml\ version/{i++}{print > "outfile."i}' test123.xml
this is producing the desired out put. but i want the the currenttimestamp with milliseconds in the... (3 Replies)
Okay, so I'm not a complete newb when it comes to using Unix/Linux. I've been using Ubuntu for a few years now and I've dipped my toes into a few other distros but now I want to get a bit serious.
I'm looking at becoming a sysadmin but the trouble is...I have no idea where to start. What I'm... (1 Reply)
Hello All,
I am writing an shell script but abruptly its not able to recognize switches in echo statement.
#!/bin/bash
top -n 1 -b>ankit
host=`hostname`
time=`cat ankit|grep load|tr -s " "|cut -d " " -f3`
load=`cat ankit|grep load|tr -s " "|cut -d "," -f4|cut -d ":" -f2`
... (3 Replies)
Hey , I have become pretty normal, using unix and what not and working around FEDORA 9
I was wondering does anyone have any IDEAS or have anything I should try to build or scripts to write ,
or possibly know any sites where I could practice some things just so I know I am writing them... (2 Replies)
Say I have a single bin directory with Linux and SunOS executables, like this:
bin/myprog_lnx
bin/myprog_sun
Assume these programs read from stdin and write to stdout and, thus, are meant to be run like this:
myprog_lnx < filein > fileout
My users may log in from a Linux or Solaris... (3 Replies)
Hi,
I have a .txt file (uniqfields.txt) with 3 fields separated by " | " (pipe symbol). This file contains unique values with respect to all these 3 fields taken together. There are about 40,000 SORTED records (rows) in this file. Sample records are given below.
1TVAO|OVEPT|VO... (2 Replies)
First, I just rebuilt/installed my custom kernel & I don't know how to check if it ran properly (I'm fairly sure it did, but I'm looking for reassurance that it loaded the new kernel file).
Second, I'd love to get into programming, scripting, whatever, I want my imagination to be the builder &... (2 Replies)
Hi,
If i want to write my data on several tapes, (more than one tape), what switch(s) i need to use with tar.
In other word if my data needs the sapce more than one tape & i don't wanna to compress or ... my data. so is it possible to write up to the end of the tape & it asks to put another... (1 Reply)