It assumes the vertical bar (|) does not exist in either input file. You could also write the whole solution with awk rather than using two processes; it's not as "clean looking" but should be more efficient.
Last edited by agama; 02-13-2012 at 11:31 PM..
Reason: remove testing extras
I wonder if any body can help me with a command i am struggling with. I have a file with around 400 lines in, in a program i have it pulls out each line at a time so that data from the line can be cross referenced with another file. If it finds a match it pulls out a ocde from the second file, this... (5 Replies)
Hello everyone,
This is Rameshreddy. I like this forum and its nice to share everyone's experience here and one can learn a lot from here. Appreciate the moderators especially.
Coming to my question i have 2 files and i want to paste them with specific number of tabs as delimiters... (4 Replies)
Hi.
I have an interesting problem and i couldn't find out the solution.
I have two variables in which there are a lot of lines finished by \n. I would like to concatenate this two variables into one in this format:
var1var2
var1var2
.
.
.
I could do this simply by command paste but it works... (32 Replies)
I have a file which contains 3 fields separated by tabs example
andrew kid baker
I need to swap kid and baker using cut and paste commands how is this to be done?
Thanks (1 Reply)
I have a file which contains 3 fields separated by tabs example
andrew kid baker
I need to swap kid and baker using cut and paste commands how is this to be done?
Thanks (3 Replies)
Hello. I've made a simple script which asks the user to input a hash and then runs a command that replaces the variable $hash with what the user inserted. The ting is that when the programm asks for input I can't paste anything there..! any clues?? :wall: (8 Replies)
Please help me. This is simple, but urgent problem for me. :(
I have a two files
file1
1 2 3 4 5 6
1 2 3 4 5 6
1 2 3 4 5 6
.....
file2
11 12 13 14 15
11 12 13 14 15
11 12 13 14 15
.....
1) I hope to make a new file, file 3, that consists of 2nd... (2 Replies)
How can I accomplish this? I basically want to merge two variables onto the same line. I can do it with two FILES this way:
$ cat /tmp/users_in.list | awk -F "," '{print $2}' | cut -c -1 > first.initial
$ awk -F "," '{print $1}' /tmp/users_in.list | awk '{print $1}' > last.name
$ paste... (5 Replies)
Hi,
I am facing issue with paste command. It is adding spaces or tab in between.
I have say 3 files with below data
File_1
TH
THI
THIS I
File_2
IS IS
S IS RE
S
File_3
RECORD 1
CORD 2
IS RECORD 3 (3 Replies)
Discussion started by: Simanto
3 Replies
LEARN ABOUT BSD
join
JOIN(1) General Commands Manual JOIN(1)NAME
join - relational database operator
SYNOPSIS
join [ options ] 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.
-jn m Join on the mth field of file n. If n is missing, use the mth field in each file.
-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)