Hi,
I'm using the join command and it appears to discard certain fields. Here are the two files i'm comparing:
File1:
1 a
2 b
3 c
4 d
99 f
101 g
999 i
200 j
File 2:
1 e
2 f
3 g
4 h
99 h (22 Replies)
Hi,
I am trying to use join command for two files of size greater than 1 GB.
join -t , -1 2 -2 1 -o 1.1,1.2,1.3,1.4,1.5,1.6,1.7,1.8,1.9,1.10,1.11,1.12,1.13,1.14,1.15,1.16,1.17,1.18,1.19,1.20,1.21,1.22,1.23 File1 File2 > File3
we are facing space crunch after using these join command.
May i... (0 Replies)
Hi,
I am a new learner of join command. Some result really make me confused.
Please kindly help me.
input:
file1:
LEO oracle engineer 210375
P.Jones Office Runner ID897
L.Clip Personl Chief ID982
S.Round UNIX admin ID6
file2:
Dept2C ID897 6 years
Dept5Z ID982 1 year
Dept3S ID6 2... (1 Reply)
Dear Experts,
I have several (say 'm') text files, each with 'n' columns. I want to put them into a large single file with n*m columns.
a 1 a 1 a 1 a 1
b 2 b 5 b 1 b 3
c 3 c 7 ... (1 Reply)
All,
I have 3 files (tab seperated):
Note: Please treat dash (-) as empty value in the file, I have added it to make input easily readable
file1: (2 cols)
A 1
B 2
C 3
file2: (4 cols - col4 has empty values for 4th column except 2nd row)
A 1 5 -
B 2 6 Y
C 3 7 -
D 4 8 -
file3... (1 Reply)
Hello,
I am using join to merge two files together. The defaults usually works great
join file1 file2 However, sometimes file1 or file2 has more keys, which I want to keep.
file 1:
-1 z
0 a
1 b
2 c
file 2:
0 a2
1 b2
2 c2
3 c3
So I do
join -a1 -a2 file1 file2 But then you don't... (0 Replies)
Hi,
I have 20 tab delimited text files that have a common column (column 1). The files are named GSM1.txt through GSM20.txt. Each file has 3 columns (2 other columns in addition to the first common column).
I want to write a script to join the files by the first common column so that in the... (5 Replies)
Hi,
Please explain the working process of join command.
File 1
P B
S A
C AFile2
C B
P A
S DBut the output of join command is...
join File1.txt File2.txt
P B A
S A DBut I guess the output should be
P B A
S A D
C A BPlease correct me,if i am worong or missing some thing.
Thanks (2 Replies)
Discussion started by: satyar
2 Replies
LEARN ABOUT REDHAT
qmail-users
qmail-users(5) File Formats Manual qmail-users(5)NAME
qmail-users - assign mail addresses to users
OVERVIEW
The file /var/lib/qmail/users/assign assigns addresses to users. For example,
=joe.shmoe:joe:503:78:/home/joe:::
says that mail for joe.shmoe should be delivered to user joe, with uid 503 and gid 78, as specified by /home/joe/.qmail.
Assignments fed to qmail-newu will be used by qmail-lspawn to control qmail-local's deliveries. See qmail-newu(8). A change to
/var/lib/qmail/users/assign will have no effect until qmail-newu is run.
STRUCTURE
/var/lib/qmail/users/assign is a series of assignments, one per line. It ends with a line containing a single dot. Lines must not contain
NUL.
SIMPLE ASSIGNMENTS
A simple assignment is a line of the form
=local:user:uid:gid:homedir:dash:ext:
Here local is an address; user, uid, and gid are the account name, uid, and gid of the user in charge of local; and messages to local will
be controlled by homedir/.qmaildashext.
If there are several assignments for the same local address, qmail-lspawn will use the first one.
local is interpreted without regard to case.
WILDCARD ASSIGNMENTS
A wildcard assignment is a line of the form
+loc:user:uid:gid:homedir:dash:pre:
This assignment applies to any address beginning with loc, including loc itself. It means the same as
=locext:user:uid:gid:homedir:dash:preext:
for every string ext.
A more specific wildcard assignment overrides a less specific assignment, and a simple assignment overrides any wildcard assignment. For
example:
+:alias:7790:2108:/var/lib/qmail/alias:-::
+joe-:joe:507:100:/home/joe:-::
=joe:joe:507:100:/home/joe:::
The address joe is handled by the third line; the address joe-direct is handled by the second line; the address bill is handled by the
first line.
SEE ALSO qmail-pw2u(8), qmail-newu(8), qmail-lspawn(8)qmail-users(5)