10-04-2013
short, terse, brilliant!
But - it depends on the file2 being in the right order and being complete. Which may not always be the case.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Guyz
I designed a script that can compare 2 columns(values) of single file and gives the closest numbers to the first column by comparing the numbers in first column with second and it works in a single file.
Now I'm trying to design a new script with 2 objectives for 2 files (not a single... (4 Replies)
Discussion started by: repinementer
4 Replies
2. Programming
I have few files which have two columns in each.
like
e2
1 1 2694
2 4 2485
3 2 2098
5 1 2079
6 5 2022
9 4 1734
11 5 1585
13 2 1461
18 1 1092
21 2 1019
24 1 915
25 3 907
27 1 891
28 3 890
34 1 748
39 1 700 (1 Reply)
Discussion started by: kamuju
1 Replies
3. Solaris
I have 3 variables with different information.. they look like this (row-wise aswell):
Variable1 =
Roland
Kalle
Dalius
Variable2 =
ake123
ler321
kaf434
Variable3 =
Richardsen
Sworden
Lokthar
How can I sort them by variable3 alphabetical and add them into the same output so... (0 Replies)
Discussion started by: Prantare
0 Replies
4. Shell Programming and Scripting
I have the following code and want to use a loop to output the results to the fparams file.
if ($optparams == 1) then
# Set the tdarwin parameters
set txt01 = "Call to raytrac.csh"
set txt02 = ""
set txt03 = "./Scripts/raytrac.csh $*"
set txt04 = ""
set txt05 =... (0 Replies)
Discussion started by: kristinu
0 Replies
5. UNIX for Dummies Questions & Answers
Hi all
I'm having a few issues with sorting some data into easily-readable columns.
Original data in file:
Number of visits IP Address
8 244.44.145.122
8 234.45.165.125
6 225.107.26.10
I firstly tried the column -t command which results in this:
Number of ... (4 Replies)
Discussion started by: semaj
4 Replies
6. UNIX for Dummies Questions & Answers
I have a list below, how can I have things separated nicely in columns
mv browseDir.tcsh browseDir.csh
mv checkSRDist.tcsh checkSRDist.csh
mv create-data-tinv.tcsh create-data-tinv.csh
mv createDocs.tcsh createDocs.csh
mv createMisfit.tcsh createMisfit.csh
mv createModel.tcsh... (4 Replies)
Discussion started by: kristinu
4 Replies
7. Shell Programming and Scripting
i have a file 'detail' which contains
cat detail
111111
222222
333333
444444
but detail may be 4 line file.6 line file or 8 line file like
cat detail
111111
222222
333333
444444
555555
666666
777777
888888
so i want a declare a loop which assign the value of first line in one... (11 Replies)
Discussion started by: rakeshtomar82
11 Replies
8. Shell Programming and Scripting
Hi, I am trying to multiply column#1 with column#2 using a shell script. How can I make a for-loop script using 1st column as "i" and the second column as "j" from the following file? Please feel free to share any alternative ways to multiplying column#1 with column#2.
.06 5.0000
.49 ... (6 Replies)
Discussion started by: momin
6 Replies
9. Shell Programming and Scripting
Hello Unix experts,
I need a help to create a subset file. I know with cut comand, its very easy to select many different columns, or threshold. But here I have a bit problem as in my data file is big. And I don't want to identify the column numbers or names manually. I am trying to find any... (7 Replies)
Discussion started by: smitra
7 Replies
10. Shell Programming and Scripting
Hi,
I have list of files present in a folder. I want to search for a particular keyword sequentially and create a file which will be later used by some other program.
Input files:
$ ls
a.dsx b.dsx c.dsx Dataline_.txt Dataline.txt loop.sh
$ cat *.dsx
help
tyiis
global
for i in... (4 Replies)
Discussion started by: mac4rfree
4 Replies
JOIN(1) General Commands Manual JOIN(1)
NAME
join - relational database operator
SYNOPSIS
join [-an] [-e s] [-o list] [-tc] file1 file2
DESCRIPTION
Join forms, on the standard output, a join of the two relations specified by the lines of file1 and file2. If file1 is `-', the standard
input is used.
File1 and file2 must be sorted in increasing ASCII collating sequence on the fields on which they are to be joined, normally the first in
each line.
There is one line in the output for each pair of lines in file1 and file2 that have identical join fields. The output line normally con-
sists of the common field, then the rest of the line from file1, then the rest of the line from file2.
Fields are normally separated by blank, tab or newline. In this case, multiple separators count as one, and leading separators are dis-
carded.
These options are recognized:
-an In addition to the normal output, produce a line for each unpairable line in file n, where n is 1 or 2.
-e s Replace empty output fields by string s.
-o list
Each output line comprises the fields specified in list, each element of which has the form n.m, where n is a file number and m is a
field number.
-tc Use character c as a separator (tab character). Every appearance of c in a line is significant.
SEE ALSO
sort(1), comm(1), awk(1).
BUGS
With default field separation, the collating sequence is that of sort -b; with -t, the sequence is that of a plain sort.
The conventions of join, sort, comm, uniq, look and awk(1) are wildly incongruous.
7th Edition April 29, 1985 JOIN(1)