Sponsored Content
Top Forums UNIX for Beginners Questions & Answers awk scripting to select a rectangle frame Post 303044190 by jeo_fb on Sunday 16th of February 2020 10:15:57 AM
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..
 

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

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

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

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

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

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

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

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

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

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... (3 Replies)
Discussion started by: dis0wned
3 Replies
euler2d(6x)							XScreenSaver manual						       euler2d(6x)

NAME
euler2d - two dimensional incompressible inviscid fluid flow. SYNOPSIS
euler2d [-display host:display.screen] [-visual visual] [-window] [-root] [-count number] [-eulertail number] [-cycles number] [-ncolors number] [-delay number] [-fps] DESCRIPTION
Simulates two dimensional incompressible inviscid fluid flow. OPTIONS
-visual visual Specify which visual to use. Legal values are the name of a visual class, or the id number (decimal or hex) of a specific visual. -window Draw on a newly-created window. This is the default. -root Draw on the root window. -count number Particles. 2 - 5000. Default: 1024. -eulertail number Trail Length. 2 - 500. Default: 10. -cycles number Duration. 100 - 5000. Default: 3000. -ncolors number Number of Colors. Default: 64. -delay number Per-frame delay, in microseconds. Default: 10000 (0.01 seconds.). -fps Display the current frame rate and CPU load. ENVIRONMENT
DISPLAY to get the default host and display number. XENVIRONMENT to get the name of a resource file that overrides the global resources stored in the RESOURCE_MANAGER property. SEE ALSO
X(1), xscreensaver(1) COPYRIGHT
Copyright (C) 2002 by Stephen Montgomery-Smith. Permission to use, copy, modify, distribute, and sell this software and its documentation for any purpose is hereby granted without fee, provided that the above copyright notice appear in all copies and that both that copyright notice and this permission notice appear in supporting documentation. No representations are made about the suitability of this software for any purpose. It is provided "as is" without express or implied warranty. AUTHOR
Stephen Montgomery-Smith. X Version 11 5.15 (28-Sep-2011) euler2d(6x)
All times are GMT -4. The time now is 02:08 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy