04-12-2007
Quote:
Originally Posted by reborg
In this case what would the expected output be. When asking questions about data processing you need to give a full example of input(s) and expect output.
I type in
join file1 file2
I would expect the output to be:
2007/04/04 Joey Jimmy
or
2007/04/04 Jimmy Joey
doesn't matter which.
Nothing shows up instead
How do I specify a space as a delimeter.
Like join -t " "
or do I have to use some ascii character like join -t "\0000"
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I can't get touch to simultaneously create three empty files file1, file2, file3. I tried:$ touch filebut all I got was one file:$ fileWhat did I do wrong? (4 Replies)
Discussion started by: na5m
4 Replies
2. Shell Programming and Scripting
Hi,
I am having issue where I have to tail 3 log files continuously (forever) and while I am reading the files , parse them and shove the data into DB. I can do this with one file totally fine but how can I read 3 files at the same time? I am not really looking for code (but would be nice) but... (3 Replies)
Discussion started by: Dabheeruz
3 Replies
3. Shell Programming and Scripting
Hi ,
I have a large no of files which all end in .asp.htm extension .
But for proper navigation between the pages I need to rename all those files as .asp only .
How can it be done ? (4 Replies)
Discussion started by: nshailesh
4 Replies
4. Shell Programming and Scripting
Hi
I've 2 folder A and B, they have files with the same name but different content.
I mean
A contain---------> aa.txt, bb.txt, cc.txt
B contain---------> aa.txt, bb.txt, cc.txt
but aa.txt in A has different content from aa.txt in B.
I'd like to parse the homonyms files in... (7 Replies)
Discussion started by: Dedalus
7 Replies
5. Shell Programming and Scripting
Hi all,
I'm having a problem with a script which should ultimately provide a filename by reading a value from file1 and file2 then join together.
I'm planning to use a loop/ loops to get the values out of both files and create a single string unfortunately the code currently treats the second... (7 Replies)
Discussion started by: chris01010
7 Replies
6. UNIX for Dummies Questions & Answers
Does anybody know how to make symbolic links for multiple files simultaneously?
Often times I need make symbolic links for multiple files with some common pattern (just like "*.jpg"). Is there a way to avoid making symbolic link for each of them one by one...
Thank you! (6 Replies)
Discussion started by: danieladna
6 Replies
7. Shell Programming and Scripting
Hi,
I have a really simple question...I think. I want to be able to parse two or more files into one by reading the first record from each file into new file then go back to the first file and start reading the second record in from each file into new file and so on. I am new to using awk and am... (5 Replies)
Discussion started by: qray2011
5 Replies
8. Shell Programming and Scripting
Hello,
Is it possible to handle data from two different files at once in awk (latest version and platform is Fedora). I found on the net that we cannot nest awk. My requirement is that I have two similar files :
File 1:
Name: abc
Val = 58
Name: cdf
Val = 1;
..................
File... (7 Replies)
Discussion started by: fifteate
7 Replies
9. Shell Programming and Scripting
dear all,
i'm preparing a script which can do these actions :
1. stop remove server's certain service
2. clean the files on remote servers simultaneously (because lots of files need to be deleted)
3. after files/logs are removed, restart the service again
i'm stuck on how to clean remote... (4 Replies)
Discussion started by: tiger2000
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)