04-19-2011
Matching Numbers in Bash/AWK
Hi,
I need to match up some numbers in one file to the closest numbers in other file and produce an output file.
File one (f1.txt) is laid out like this
|
PCode Lon Lat |
AB10 1AA 57.148235 -2.096648 |
BB2 3JD 53.728563 -2.47852 |
LU4 9ET 51.912308 -0.4785 |
etc,,,,
File two (F2.txt) is liad out like this
|
Node Lon Lat |
1 48.39 -13.0 |
2 48.39 -12.89 |
.......... |
7079 51.91 -2.0 |
10779 53.78 -2.44 |
17322 57.09 -2.11 |
etc,,,
And I would like the output file to read
|
Pcode Lon Lat Lon Lat Node |
AB10 1AA 57.148235 -2.096648 57.09 -2.11 17322 |
BB2 3JD 53.728563 -2.47852 53.78 -2.44 10779 |
LU4 9ET 51.912308 -0.4785 51.91 -2.0 7079 |
As you can see I need to find the closest match from collumn 2 on boths files and collumn 3 on both files and output the above.
Many thanks,
Ian
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi all
I have a 2 files. both the files have some numbers and i want to find out each number in file1 is existing or not in file2. if not then put it into new file. if yes then also in a seperate file
i can not use diff command as the files are different and no order has been defined.
... (2 Replies)
Discussion started by: infyanurag
2 Replies
2. Shell Programming and Scripting
I know how to do this in perl, but I want to do it in bash script. Hope some one could help me, many thanks!
I have a file looks like this:
AB_21423 *********
BC_123 *********
CD_343 *********
AB_289 *********
***************
***************
I... (5 Replies)
Discussion started by: zx1106
5 Replies
3. Shell Programming and Scripting
Hello all,
can you help me in this problem, assume We have two txt file (file_1 and file_3) one is file_1 contains the data:
a 0
b 1
c 3
a 7
b 4
c 5
b 8
d 6
.
.
.
.
and I need to count the lines with the matching data (a,b,..) and print in new file called file_2 such as the... (4 Replies)
Discussion started by: GoldenFalcon10
4 Replies
4. Shell Programming and Scripting
Hi friends,,
I need ur help very urgently.I have 2 files which have more than 5000 numbers,I want to find the matching numbers between 2 files using R language.I dont know how to use for loop in R.I tried to get a result,,but didnt get,
file1 is like
1061909
1162391... (1 Reply)
Discussion started by: sureshraj
1 Replies
5. UNIX for Dummies Questions & Answers
Dear all,
I'm stuck on a certain problem regarding counting the number of characters in one line and then adjusting the number of characters of another line to this number.
This was my original input data:
@HWI-ST471_57:1:1:1231:2079/2... (4 Replies)
Discussion started by: DerSeb
4 Replies
6. Shell Programming and Scripting
Experts:
I don't know that regular expressions will ever be easy for me, so if one of you guru's could help out, I'd appreciate it.
I'm trying to match a line in our syslog, but I can't figure out how to match a number inside a bracket. This is what I'm trying to match.
"Jul 16 00:01:34... (2 Replies)
Discussion started by: jdveencamp
2 Replies
7. Shell Programming and Scripting
Hi All,
I have a file which looks like this:
abc 1
abc 2
abc 3
abc 4
abc 5
bcd 1
bcd 3
bcd 3
bcd 5
cde 7
This file is just a miniature version of what I really have. Original file is some 1 million lines long.
I have tried to come up with the code for what I wish to accomplish... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies
8. Shell Programming and Scripting
Hi,
I have one file 1.txt with one field consist of following Ids (shortlisted 10 but showing 3 here):
00052
00184
00607
and then second file 2.txt with three fields (very big file):
00052 00184 12.73062
00052 00598 13.51205
00052 00599 13.92554
00052 00600 13.73358... (2 Replies)
Discussion started by: bioinfo
2 Replies
9. Shell Programming and Scripting
Hi All,
Can some one help me in identifying the significance of character "$" ,Which is playing critical role in matching decimal point numbers as below.
$ echo "01#.01"|awk '{if ($0 ~ /^+(\.*)?$/) print}'
$ echo "01#.01"|awk '{if ($0 ~ /^+(\.*)?/) print}'
01#.01
$
Regards,
Rmkganesh. (3 Replies)
Discussion started by: rmkganesh
3 Replies
10. Shell Programming and Scripting
Using the awk below I am able to combine all the matching dates in $1, but I can not seem to remove the non-matching from the file. Thank you :).
file
20161109104500.0+0000,x,5631
20161109104500.0+0000,y,2
20161109104500.0+0000,z,2
20161109104500.0+0000,a,4117... (3 Replies)
Discussion started by: cmccabe
3 Replies
LEARN ABOUT SUSE
drop_table
DROP
TABLE(7) SQL Commands DROP TABLE(7)
NAME
DROP TABLE - remove a table
SYNOPSIS
DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP TABLE removes tables from the database. Only its owner can drop a table. To empty a table of rows without destroying the table, use
DELETE [delete(7)] or TRUNCATE [truncate(7)].
DROP TABLE always removes any indexes, rules, triggers, and constraints that exist for the target table. However, to drop a table that is
referenced by a view or a foreign-key constraint of another table, CASCADE must be specified. (CASCADE will remove a dependent view
entirely, but in the foreign-key case it will only remove the foreign-key constraint, not the other table entirely.)
PARAMETERS
IF EXISTS
Do not throw an error if the table does not exist. A notice is issued in this case.
name The name (optionally schema-qualified) of the table to drop.
CASCADE
Automatically drop objects that depend on the table (such as views).
RESTRICT
Refuse to drop the table if any objects depend on it. This is the default.
EXAMPLES
To destroy two tables, films and distributors:
DROP TABLE films, distributors;
COMPATIBILITY
This command conforms to the SQL standard, except that the standard only allows one table to be dropped per command, and apart from the IF
EXISTS option, which is a PostgreSQL extension.
SEE ALSO
ALTER TABLE [alter_table(7)], CREATE TABLE [create_table(7)]
SQL - Language Statements 2010-05-14 DROP TABLE(7)