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 MOJAVE

tcl_dontcallwhendeleted

Tcl_CallWhenDeleted(3)					      Tcl Library Procedures					    Tcl_CallWhenDeleted(3)

__________________________________________________________________________________________________________________________________________________

NAME

       Tcl_CallWhenDeleted, Tcl_DontCallWhenDeleted - Arrange for callback when interpreter is deleted

SYNOPSIS

       #include <tcl.h>

       Tcl_CallWhenDeleted(interp, proc, clientData)

       Tcl_DontCallWhenDeleted(interp, proc, clientData)

ARGUMENTS

       Tcl_Interp *interp (in)			     Interpreter with which to associated callback.

       Tcl_InterpDeleteProc *proc (in)		     Procedure to call when interp is deleted.

       ClientData clientData (in)		     Arbitrary one-word value to pass to proc.
_________________________________________________________________

DESCRIPTION

       Tcl_CallWhenDeleted arranges for proc to be called by Tcl_DeleteInterp if/when interp is deleted at some future time.  Proc will be invoked
       just before the interpreter is deleted, but the interpreter will still be valid at the time of the call.  Proc should  have  arguments  and
       result that match the type Tcl_InterpDeleteProc:
	      typedef void Tcl_InterpDeleteProc(
		      ClientData clientData,
		      Tcl_Interp *interp);
       The clientData and interp parameters are copies of the clientData and interp arguments given to Tcl_CallWhenDeleted.  Typically, clientData
       points to an application-specific data structure that proc uses to perform cleanup when an interpreter is about to go away.  Proc does  not
       return a value.

       Tcl_DontCallWhenDeleted	cancels  a previous call to Tcl_CallWhenDeleted with the same arguments, so that proc will not be called after all
       when interp is deleted.	If there is no deletion callback that matches interp, proc, and clientData  then  the  call  to  Tcl_DontCallWhen-
       Deleted has no effect.

KEYWORDS

       callback, delete, interpreter

Tcl									7.0						    Tcl_CallWhenDeleted(3)