awk scripting to select a rectangle frame Post: 303044258

Sponsored Content

Top Forums UNIX for Beginners Questions & Answers awk scripting to select a rectangle frame Post 303044258 by rdrtx1 on Monday 17th of February 2020 01:11:58 PM

02-17-2020

Read Only

- an area solution ex.:

Code:

awk '
function triangle_area(x1, y1, x2, y2, x3, y3) {
#
# determine area of triangle with the 3 points given
#
area=((x1 * (y2 - y3) + x2 * (y3 - y1) + x3 * (y1 - y2)) / 2.0);
#
# return absolute value of area. area value should be positive. unless you are on drugs.
#
return area < 0 ? -area : area;
}
FILENAME ~ /rectangle/ {
if (! repeat_line[$0]++) {
#
# load points of rectangle in x, y arrays.
#
x[NR]=$1;
y[NR]=$2;
} else {
#
# repeat line found so rectangle is closed. that is nice.
# calculate area of rectangle by adding area of two triangles that make up rectangle
#
Rectangle_area=triangle_area(x[1], y[1], x[2], y[2], x[3], y[3]) + triangle_area(x[1], y[1], x[3], y[3], x[4], y[4]);
}
}
FILENAME ~ /positions/ {
#
# determine area of 4 triangles made up of latitude, longitude point and each side of rectangle
#
triangle1=triangle_area(x[1], y[1], $1, $2, x[2], y[2]);
triangle2=triangle_area(x[2], y[2], $1, $2, x[3], y[3]);
triangle3=triangle_area(x[3], y[3], $1, $2, x[4], y[4]);
triangle4=triangle_area(x[1], y[1], $1, $2, x[4], y[4]);
#
# if rectangle area equals to total area of 4 triangles then point is inside rectangle. it is obvious if you think about it.
#
if (Rectangle_area==triangle1+triangle2+triangle3+triangle4) print $0;
}
' rectangle positions

note, example posted uses format of input/output files shown (not csv, as stated).

Last edited by Neo; 02-28-2020 at 01:17 AM..

rdrtx1

View Public Profile for rdrtx1

Find all posts by rdrtx1

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

SED scripting select

Say I have a file 'example.txt' with these lines of code in it: hello:anddasd:cheese:gerg whatever:sdadsa:asdfasdfa:wwew hmmmm:something:gfhfhgf:sdasdas Question: 1. How would I write a script which is able to take all the words before the first ':'? 2. How would I write a script which is...

2. UNIX for Dummies Questions & Answers

Awk - select from a list

Hi all, I am trying to select some columns from a file, based on the list of values. Would like to know how best I can achive this. If coulmn 1 has a value of 57 then print the ist column (This works) awk -F' ' '{if ( $1 == 57 ) {print $1}}' file.txt Now my requirement is that I have to...

3. Shell Programming and Scripting

SQL Select and awk

Dear All , I have file1.txt contain values like the following: ---------- 23 24 25 and I have shell script which has the following : more file1.txt | awk '{print "select 'DUMP',CODE1||'|'||CODE2||'|'||CODE3 from CODE where CODE1='" $1 "';"}' > file2.sql all I need is to have the...

4. Shell Programming and Scripting

Removing repeating lines from a data frame (AWK)

Hey Guys! I have written a code which combines lots of files into one big file(.csv). However, each of the original files had headers on the first line, and now that I've combined the files the headers are interspersed throughout the new combined data frame. For example, throughout the data...

5. Shell Programming and Scripting

awk with fields select?

If i have a log file record.txt, with 10 fields - First field is datetime - 7th field is status - 8th filed is name - The last field (10th) is epoch time of the first field 02/17/2012 1:47 PM||||||In Use|chicken||1329515230 02/17/2012 2:53 PM||||||Available|chicken||1329519195 02/17/2012...

6. Shell Programming and Scripting

awk : Search for text between two time frame (12 hours)

I have created the script to grep the errors from weblogic logs files and redirecting output to file.txt ...From file.txt I'm using awk command to collect the past 20 mins output...The script running from cron every 15 mins... The script working well... Now the challenges, I'm trying to use...

7. Shell Programming and Scripting

awk : collecting all data between two time frame

Hi Experts , I need your help to collect the complete data between two time frame from the log files, when I try awk it's collecting the data only which is printed with time stamp for example, awk works well from "16:00 to 17:30" but its not collecting <line*> "from 17:30 to 18:00" ...

8. Shell Programming and Scripting

Using awk to select one field

Hi, I saw your post.. I have a dought in awk command... how to get the output from a file. i need a first column in etc/passwd file in a single column (in indivijual line)... i couldn't get with this command cat /etc/passwd | awk -F ":" '{printf $1}' Kindly help This thread was created...

9. UNIX and Linux Applications

Rectangle is flickering while dragging on screen with xlib

Hi, this is my first post here. I wanto make a screencasting program. I want to make a screen part selection to grab coordinates of the screen location. I found a nice prototype #include <X11/Xlib.h> //#include <X11/Xresource.h> #include <stdlib.h> #include <stdio.h> #include...

10. Shell Programming and Scripting

Shell Scripting - Select multiple files from numbered list

I am trying to have the user select two files from a numbered list which will eventually be turned into a variable then combined. This is probably something simple and stupid that I am doing. clear echo "Please Select the Show interface status file" select FILE1 in *; echo "Please Select the...

LEARN ABOUT NETBSD

scc

SCC(4)							   BSD Kernel Interfaces Manual 						    SCC(4)

NAME

     scc -- Zilog 8530 Serial Communications Controller interface

SYNOPSIS

     scc* at ioasic? offset ?

DESCRIPTION

     The scc driver provides support for the Zilog 8530 Serial Communications Controller (SCC) via the IOASIC found on DECstation 5000 models in
     the /100, /20, and /240 series (supported by NetBSD/pmax).

     Each SCC device has two serial ports.  The DECstation 5000 model 20 provides one SCC device.  Other models provide two, but one port of each
     device is dedicated to mouse and keyboard input, respectively.

     Input and output for each line may set to one of following baud rates: 50, 75, 110, 134.5, 150, 300, 600, 1200, 1800, 2400, 4800, 9600,
     19200, 38400, or 57600.

     Speeds up to 230400 are supported by the chip and the motherboard, but speeds higher than 57600 do not work reliably without an external
     clock signal.

FILES

     /dev/ttya
     /dev/ttyb
     /dev/ttyc
     /dev/ttyd

     The mapping from units to serial-hardware outlets is idiosyncratic.  The even ports are wired serial connectors and the odd-numbered ports
     are reserved for mouse and keyboard.

     On machines with one port like Personal DECstations, the single device is ttya.

     On the 5000/1xx and 5000/2xx, the first serial port (default serial console) is ttyc and the second port is ttya.

SEE ALSO

     intro(4), ioasic(4), ttys(5), MAKEDEV(8)

HISTORY

     The scc driver first appeared in 4.4BSD.

     The scc driver was also used for the IOASIC SCC found in DEC Alpha model 3000 TurboCHANNEL based systems; NetBSD/alpha has since been con-
     verted to use the machine-independent zstty(4).

BUGS

     The IOASIC provides internal DMA channels that can be programmed to transfer up to 4096 bytes of data into, or out, of an SCC without further
     software intervention.  This feature of the IOASIC is not yet supported.

     The mapping from device-special files (major and minor number) to chip and port is arguably backwards.  ULTRIX tries to hide the hardware
     mapping, but NetBSD does not.  Users wanting to use ULTRIX compatible tty names /dev/tty0 and /dev/tty1 for the scc comm-port lines should
     make links or device-special files which match their hardware setup.

BSD
								  April 24, 2003							       BSD