Sponsored Content
Top Forums Shell Programming and Scripting Ranking data points from multiple files Post 302978688 by Don Cragun on Tuesday 2nd of August 2016 02:47:10 PM
Old 08-02-2016
And when I run the script I suggested with those three files, I get the output:
Code:
24.5625	-81.8125	39.16	1
24.5625	-81.8125	74.28	2
24.5625	-81.7708	40.81	1
24.5625	-81.7708	72.68	2
24.5625	-81.7292	46.73	1
24.5625	-81.7292	66.90	2
24.5625	-81.6875	52.67	1
24.5625	-81.6875	61.92	2
24.6042	-81.6458	57.16	1
24.6042	-81.6458	62.22	2
24.6458	-81.5625	60.11	1
24.6458	-81.5625	66.18	2
24.6458	-81.4792	62.80	1
24.6458	-81.4792	68.19	2
24.6875	-81.5625	62.20	1
24.6875	-81.5625	67.32	2
24.6875	-81.3958	68.01	1
24.6875	-81.3958	71.72	2
24.7292	-81.3958	69.86	1
24.7292	-81.3958	73.26	2
24.7708	-80.9375	85.71	1
24.7708	-80.9375	90.29	2
25.1458	-81.1042	116.34	1
25.1458	-81.1042	159.11	2
25.1458	-81.0625	117.04	1
25.1458	-81.0625	161.78	2
25.1458	-81.0208	119.01	1
25.1458	-81.0208	162.54	2
25.1458	-80.9792	118.53	1
25.1458	-80.9792	163.41	2
25.1458	-80.9375	118.07	1
25.1458	-80.9375	169.29	2
25.1458	-80.7708	142.98	1
25.1458	-80.7708	150.50	2
25.1458	-80.7292	145.82	1
25.1458	-80.7292	149.23	2
25.1458	-80.4375	122.51	1
25.1458	-80.4375	171.91	2
25.1458	-80.3958	120.30	1
25.1458	-80.3958	172.67	2
25.1875	-81.1042	122.42	1
25.1875	-81.1042	168.44	2
25.1875	-81.0625	125.46	1
25.1875	-81.0625	170.80	2
25.1875	-81.0208	125.53	1
25.1875	-81.0208	173.15	2
25.1875	-80.9792	125.67	1
25.1875	-80.9792	176.74	2
25.1875	-80.9375	127.46	1
25.1875	-80.9375	176.95	2
25.1875	-80.8958	130.94	1
25.1875	-80.8958	176.87	2

Which lines in this output have a point1, point2 pair that is not present in the file 201606.pnt?

If I add one more line to 201506.pnt containing:
Code:
1 2 3

which is a point1, point2 pair that is not present in 201606.pnt and rerun the script; I get exactly the same output showing that the line I added was ignored since that point pair is not present in 201606.pnt.

Please explain what the script I suggested is doing incorrectly with the new data you just showed us in post #42?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

to extarct data points

suppose u have a file which consist of many data points separated by asterisk Question is to extract third part in each line . 0.0002*0.003*-0.93939*0.0202*0.322*0.3332*0.2222*0.22020 0.003*0.3333*0.33322*-0.2220*0.3030*0.2222*0.3331*-0.3030 0.0393*0.3039*-0.03038*0.033*0.4033*0.30384*0.4048... (5 Replies)
Discussion started by: cdfd123
5 Replies

2. Shell Programming and Scripting

recoding data points using SED??

Hello all, I have a data file that needs some serious work...I have no idea how to implement the changes that are needed! The file is a genotypic file with >64,000 columns representing genetic markers, a header line, and >1100 rows that looks like this: ID 1 2 3 4 ... (7 Replies)
Discussion started by: doobedoo
7 Replies

3. Shell Programming and Scripting

Group search (multiple data points) in Linux

Hi All I have a data set like this tab delimited: weft fgr-1 345 -1 fgrythdgd weft fgr-3 456 -2 ghjdklflllff weft fgr-11 456 -3 ghtjuffl weft fgr-1 213 -2 ghtyjdkl weft fgr-34 567 -5 fghytkflf frgt fgr-36 567 -1 ghrjufjf frgt fgr-45 678 -2 ghjruir frgt fgr-34 546 -5 gjjjgkldlld frgt... (4 Replies)
Discussion started by: Lucky Ali
4 Replies

4. UNIX for Dummies Questions & Answers

How to get data only inside polygon created by points which is part of whole data from file?

hiii, Help me out..i have a huge set of data stored in a file.This file has has 2 columns which is latitude & longitude of a region. Now i have a program which asks for the number of points & based on this number it asks the user to enter that latitude & longitude values which are in the same... (7 Replies)
Discussion started by: reva
7 Replies

5. Programming

GNUPLOT- how to change the style of data points

Hi, I am trying to arrange my graphs with GNUPLOT. Although it looked like simple at the beginning, I could not figure out an answer for the following: I want to change the style of my data points (not the line, just exact data points) The terminal assigns first + and then x to them but what I... (0 Replies)
Discussion started by: natasha
0 Replies

6. UNIX for Dummies Questions & Answers

Using AWK: Extract data from multiple files and output to multiple new files

Hi, I'd like to process multiple files. For example: file1.txt file2.txt file3.txt Each file contains several lines of data. I want to extract a piece of data and output it to a new file. file1.txt ----> newfile1.txt file2.txt ----> newfile2.txt file3.txt ----> newfile3.txt Here is... (3 Replies)
Discussion started by: Liverpaul09
3 Replies

7. UNIX for Dummies Questions & Answers

Finding data value that contains x% of points

Hi, I need help on finding the value of my data that encompasses certain percentage of my total data points (n). Attached is an example of my data, n=30. What I want to do is for instance is find the minimum threshold that still encompasses 60% (n=18), 70% (n=21) and 80% (n=24). manually to... (4 Replies)
Discussion started by: ida1215
4 Replies

8. Shell Programming and Scripting

Grabbing data between 2 points in text file

I have a text file that shows the output of my solar inverters. I want to separate this into sections. overview , device 1 , device 2 , device 3. Each device has different number of lines. but they all have unique starting points. Overview starts with 6 #'s, Devices have 4#'s and their data starts... (6 Replies)
Discussion started by: Mikey
6 Replies

9. UNIX for Dummies Questions & Answers

Stack data from multiple files into one, with variable column files

Hello Gurus, Im new to scripting. Got struck with a file merge issue in Unix. Was looking for some direction and stumbled upon this site. I saw many great posts and replies but couldnt find a solution to my issue. Greatly appreciate any help.. I have three csv files -> Apex_10_Latest.csv,... (1 Reply)
Discussion started by: wamshi
1 Replies

10. Shell Programming and Scripting

In PErl script: need to read the data one file and generate multiple files based on the data

We have the data looks like below in a log file. I want to generat files based on the string between two hash(#) symbol like below Source: #ext1#test1.tale2 drop #ext1#test11.tale21 drop #ext1#test123.tale21 drop #ext2#test1.tale21 drop #ext2#test12.tale21 drop #ext3#test11.tale21 drop... (5 Replies)
Discussion started by: Sanjeev G
5 Replies
ascii(7)						 Miscellaneous Information Manual						  ascii(7)

Name
       ascii - map of ASCII character set

Syntax
       cat /usr/pub/ascii

Description
       The file is a map of the ASCII character set, to be printed as needed.  It contains:
       |000 nul|001 soh|002 stx|003 etx|004 eot|005 enq|006 ack|007 bel|
       |010 bs |011 ht |012 nl |013 vt |014 np |015 cr |016 so |017 si |
       |020 dle|021 dc1|022 dc2|023 dc3|024 dc4|025 nak|026 syn|027 etb|
       |030 can|031 em |032 sub|033 esc|034 fs |035 gs |036 rs |037 us |
       |040 sp |041  ! |042  " |043  # |044  $ |045  % |046  & |047  ' |
       |050  ( |051  ) |052  * |053  + |054  , |055  - |056  . |057  / |
       |060  0 |061  1 |062  2 |063  3 |064  4 |065  5 |066  6 |067  7 |
       |070  8 |071  9 |072  : |073  ; |074  < |075  = |076  > |077  ? |
       |100  @ |101  A |102  B |103  C |104  D |105  E |106  F |107  G |
       |110  H |111  I |112  J |113  K |114  L |115  M |116  N |117  O |
       |120  P |121  Q |122  R |123  S |124  T |125  U |126  V |127  W |
       |130  X |131  Y |132  Z |133  [ |134   |135  ] |136  ^ |137  _ |
       |140  ` |141  a |142  b |143  c |144  d |145  e |146  f |147  g |
       |150  h |151  i |152  j |153  k |154  l |155  m |156  n |157  o |
       |160  p |161  q |162  r |163  s |164  t |165  u |166  v |167  w |
       |170  x |171  y |172  z |173  { |174  | |175  } |176  ~ |177 del|

       | 00 nul| 01 soh| 02 stx| 03 etx| 04 eot| 05 enq| 06 ack| 07 bel|
       | 08 bs | 09 ht | 0a nl | 0b vt | 0c np | 0d cr | 0e so | 0f si |
       | 10 dle| 11 dc1| 12 dc2| 13 dc3| 14 dc4| 15 nak| 16 syn| 17 etb|
       | 18 can| 19 em | 1a sub| 1b esc| 1c fs | 1d gs | 1e rs | 1f us |
       | 20 sp | 21  ! | 22  " | 23  # | 24  $ | 25  % | 26  & | 27  ' |
       | 28  ( | 29  ) | 2a  * | 2b  + | 2c  , | 2d  - | 2e  . | 2f  / |
       | 30  0 | 31  1 | 32  2 | 33  3 | 34  4 | 35  5 | 36  6 | 37  7 |
       | 38  8 | 39  9 | 3a  : | 3b  ; | 3c  < | 3d  = | 3e  > | 3f  ? |
       | 40  @ | 41  A | 42  B | 43  C | 44  D | 45  E | 46  F | 47  G |
       | 48  H | 49  I | 4a  J | 4b  K | 4c  L | 4d  M | 4e  N | 4f  O |
       | 50  P | 51  Q | 52  R | 53  S | 54  T | 55  U | 56  V | 57  W |
       | 58  X | 59  Y | 5a  Z | 5b  [ | 5c   | 5d  ] | 5e  ^ | 5f  _ |
       | 60  ` | 61  a | 62  b | 63  c | 64  d | 65  e | 66  f | 67  g |
       | 68  h | 69  i | 6a  j | 6b  k | 6c  l | 6d  m | 6e  n | 6f  o |
       | 70  p | 71  q | 72  r | 73  s | 74  t | 75  u | 76  v | 77  w |
       | 78  x | 79  y | 7a  z | 7b  { | 7c  | | 7d  } | 7e  ~ | 7f del|

Files
																	  ascii(7)
All times are GMT -4. The time now is 07:31 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy