Visit Our UNIX and Linux User Community


awk scripting to select a rectangle frame


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers awk scripting to select a rectangle frame
# 1  
Old 02-16-2020
awk scripting to select a rectangle frame

Hi everybody,
I have a csv file as below;

Latitude Longitude
Code:
38.9900 38.3000
38.3000 37.1300
37.0200 36.1100
37.6500 36.7600
38.8700 37.7500
38.0900 39.0000
38.7400 39.6700
39.0300 40.9700
38.0100 38.2400
37.0200 37.0000
37.5000 36.3000
38.2700 39.1600
38.2400 38.3200
38.2700 38.9900
38.5100 39.2500
38.3000 38.3000
38.9600 39.3200
39.0000 38.0000
37.6900 38.8200
38.0100 38.2400
37.5000 39.5000

I want to select lines in a rectangle frame whose corners are;

Latitude Longitude
Code:
37.0000 36.5000
37.5000 36.5000
39.5000 41.0000
39.0000 41.0000
37.0000 36.5000

Please help!
Thank you

Moderator's Comments:
Mod Comment Please do wrap your samples and codes into CODE TAGS as per forum rules.

Last edited by RavinderSingh13; 02-16-2020 at 11:21 AM..
# 2  
Old 02-16-2020
Hello jeo_fb,

Sorry but this is NOT the way UNIX.com forums work. We do encourage people to add their efforts which they have put in order to solve their own problems, so please do add your efforts in your question and let us know then. Your question is also NOT having clear information about how you want to achieve your goal, so kindly do add the rules, conditions and logic by which you want to achieve your goal.

Thanks,
R. Singh

Last edited by RavinderSingh13; 02-16-2020 at 01:14 PM..
# 3  
Old 02-16-2020
Hello again,

I made many efforts for sure my code is below;

Code:
awk '$1 >=37.0000 && $1 <= 37.5000 && $1 >=39.0000 && $1 <= 39.5000 && $1>=36.5000 && $1 <=41.0000 {print $0}' txtfile

However it did not work correctly.
# 4  
Old 02-16-2020
interesting puzzle!
Are you saying one has to "draw" an imaginary rectangle frame given the input coordinates?
I'm saying "imaginary", because the desired output coordinates are not in your input file.

Very interesting puzzle, but I'm not sure of the algorithm - it's definitely not what you tried.

Last edited by vgersh99; 02-16-2020 at 12:58 PM..
This User Gave Thanks to vgersh99 For This Post:
# 5  
Old 02-16-2020
I was thinking the same thing; but refrained from commenting .....

But I had trouble seeing any tangible relationship between the "attempt" and the original post.

I think better we tag this thread amber again and ask the OP to perform a "real attempt" to solve his problem, and add the output or error messages in reply before offering more answers.
# 6  
Old 02-16-2020
Hi again,

I want to select lines in an imaginary rectangle frame whose corners are;

Code:
 Latitude Longitude
37.0000 36.5000
37.5000 36.5000
39.5000 41.0000
39.0000 41.0000
37.0000 36.5000

For example I do not want to line including;
39.0000 38.0000
Because it is not in the rectangle.

I hope I could explain my problem.
Thank you.
Moderator's Comments:
Mod Comment
Please use code tags when posting data and code samples!

Last edited by vgersh99; 02-16-2020 at 01:47 PM.. Reason: code tags, please!
# 7  
Old 02-16-2020
Quote:
Originally Posted by jeo_fb
Hi again,

I want to select lines in an imaginary rectangle frame whose corners are;

Latitude Longitude
37.0000 36.5000
37.5000 36.5000
39.5000 41.0000
39.0000 41.0000
37.0000 36.5000
Not being a native speaker, I think this is not a rectangle. It is a parallelogram or a rhombus / rhomboid.


Quote:
For example I do not want to line including;
39.0000 38.0000
This is a coordinate pair, a point in a plane. A line needs at least one more point.

Quote:
Because it is not in the rectangle.
Should a line dissect that geometric shape, or lie entirely within?


Pls tell us how to interpret your "coordinate list".
This User Gave Thanks to RudiC For This Post:

Previous Thread | Next Thread
Test Your Knowledge in Computers #977
Difficulty: Medium
A Linux Kernel Code of Conflict was introduced on 8 March 2012.
True or False?

10 More Discussions You Might Find Interesting

1. 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... (3 Replies)
Discussion started by: dis0wned
3 Replies

2. 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... (0 Replies)
Discussion started by: whatnext
0 Replies

3. 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... (3 Replies)
Discussion started by: Dheepak s
3 Replies

4. 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 Replies)
Discussion started by: zenkarthi
8 Replies

5. 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... (27 Replies)
Discussion started by: zenkarthi
27 Replies

6. 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... (4 Replies)
Discussion started by: sabercats
4 Replies

7. 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... (21 Replies)
Discussion started by: gd9629
21 Replies

8. 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... (6 Replies)
Discussion started by: habuzahra
6 Replies

9. 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... (14 Replies)
Discussion started by: simha77777
14 Replies

10. 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... (6 Replies)
Discussion started by: i_am_a_robot
6 Replies

Featured Tech Videos