06-20-2008
Joining columns from two files, if the key matches
I am trying to join/paste columns from two files for the rows with matching first field. Any help will be appreciated.
Files can not be sorted and may not have all rows in both files.
Thanks.
File1
aaa 111
bbb 222
ccc 333
File2
aaa sss mmmm
ccc kkkk llll
ddd xxx yyy
Want to generate:
aaa 111 sss mmmm (column 2 from file1 and clolumns from file2)
bbb 222 ????? (missing data, identified)
ccc 333 kkkk llll
ddd ???? xxx yyyy (missing column 1 data marked as missing.)
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I've got two files, File1 and File2
File 1 has got combination of col1, col2 and col3 which comes on file2 as well, file2 does not get
col4. Now based on col1, col2 and col3, I would like to get col4 from file1 and all the columns from file2 in a new file
Any ideas?
File1
------
Col1 col2... (11 Replies)
Discussion started by: rudoraj
11 Replies
2. Shell Programming and Scripting
Hi
I have to join two files based on 1st column where 4th column of a2.txt=at and take 2nd column of a1.txt and 3rd column of a2.txt and check against source files ,if matches list those source file names.
a1.txt
a1|20090809|20090810
a2|20090907|20090908
a2.txt
a1|d|file1.txt|at... (9 Replies)
Discussion started by: akil
9 Replies
3. Shell Programming and Scripting
foo.txt
1 rs2887286 0 1145994 C T
1 rs1240743 0 1323299 C A
1 rs1695824 0 1355433 G T
1 rs3766180 0 1468016 G A
1 rs7519837 0 1500664 A G
1 rs2272908 0 ... (12 Replies)
Discussion started by: genehunter
12 Replies
4. Shell Programming and Scripting
Hi again,
I have monthly one-column files of roughly around 10 years. Is there a more efficient way to concatenate these files column-wise other than using paste command? For instance:
file1.txt
12
13
15
12
file2.txt
14
15
18
19
file3.txt
20
21 (8 Replies)
Discussion started by: ida1215
8 Replies
5. Shell Programming and Scripting
I have two text files that look something like this:
A:B:C 123
D:E:F 234
G:H:I 345
J:K:L 123
M:N:O 456
P:Q:R 567
A:B:C 456
D:E:F 567
G:H:I 678
J:K:L 456
M:N:O 789
P:Q:R 890
I want to find the line where the first column matches and then combine the second columns into a single... (8 Replies)
Discussion started by: pbluescript
8 Replies
6. UNIX for Dummies Questions & Answers
Hello again,
I am trying to join 3rd column of 3 files into the end on one file and save it separately... my data looks like this
file 1
Bob, Green, 80
Mark, Brown, 70
Tina, Smith, 60
file 2
Bob, Green, 70
Mark, Brown, 60
Tina, Smith, 50
file 3
Bob, Green, 50
Mark, Brown,60
Tina,... (6 Replies)
Discussion started by: A-V
6 Replies
7. Shell Programming and Scripting
Hi All,
I have a XML file which is looks like as below. <<please see the attachment >>
<?xml version="1.0" encoding="UTF-8"?>
<esites>
<esite>
<name>XXX.com</name>
<storeId>10001</storeId>
<module>
... (4 Replies)
Discussion started by: Rajeev_hbk
4 Replies
8. Shell Programming and Scripting
Hello All
I'm joining two files using Awk by Left outer join on the file 1
File 1
1 AA
2 BB
3 CC
4 DD
File 2
1 IND 100 200 300
2 AUS 400 500 600
5 USA 700 800 900 (18 Replies)
Discussion started by: venkat_reddy
18 Replies
9. Shell Programming and Scripting
Hi All,
I am looking to join two files where column 1 of file A matches with column 1 of file B and column 5 of files A matches with column 2 of file B. After joining the files based on above condition, out should contain entire line of file A and column 3, 4 and 5 of file B.
Here is sample... (8 Replies)
Discussion started by: angshuman
8 Replies
10. UNIX for Beginners Questions & Answers
Hi friends,
i want to compare first columns from two different files ,if equal print the file2's second column else print the zero.Please help me...
file1:
a
b
c
d
efile2:
a 1
c 20
e 30
desired output:
1
0
20
0
30
Please use CODE tags as required by forum rules!
Please post in... (1 Reply)
Discussion started by: bhaskar illa
1 Replies
LEARN ABOUT DEBIAN
nuaclgen
NUACLGEN(8) NUACLGEN(8)
NAME
nuaclgen - NUFW acl generator
SYNOPSIS
nuaclgen [ --Schema eq|ineq ] [ --Aclname ACLDN ] [ --saddr NETWORK1 ] [ --daddr NETWORK2 ] [ --proto PROTONUMBER ] [ --sport P1[:P2] ] [
--dport P3[:P4] ] [ --OsName OSNAME ] [ --OsVersion OSVERSION ] [ --OsRelease OSRELEASE ] [ --AppName APPLICATION NAME ] [ --AppSig APPLI-
CATION SIGNATURE ] [ --Separator SEPARATOR ] [ --jump [ACCEPT|DROP] ] [ --groups GROUPLIST ]
nuaclgen [ --List ] [ --groups Id Group ]
nuaclgen [ --Delete DN ]
nuaclgen [ --help ]
DESCRIPTION
This manual page documents the nuaclgen command.
nuaclgen is an Access control list generator for the ldap backend of Nuauth, the authentication server of the NUFW package.
Original packaging and informations and help can be found from http://www.nufw.org/
OPTIONS
--Schema eq|ineq
Use equality schema or not (Equality schema requires dport be specified, and is the default.
--AclName Acl DN
Add an acl in the ldap tree with dn Acl DN
--saddr Network
Specify source network for the acl, with network of the form : aaa.bbb.ccc.ddd[/ee]. Default value : 0.0.0.0/0
--daddr Network
Specify destination network for the acl, with network of the form : aaa.bbb.ccc.ddd[/ee]. Default value : 0.0.0.0/0
--proto Protocol number
Specify protocol type for the acl
--sport Source port
Specify source port(s) for the Acl. NNNN:MMMM can be used to specify a port range.
--dport Destination port
Specify destination port(s) for the Acl. NNNN:MMMM can be used to specify a port range.
--jump Decision
Specify decision for the Acl. Has to be ACCEPT or DROP.
--groups Groups list
Specify the user group(s) on which Acl apply. Must be of the form : Group1[,Group2[,...]]
--List --group Group ID
List Acls for the Group ID group
--Delete Dn
Deletes the Acl stored in the provided Dn
--help Displays a brief resume of available options and quits
SEE ALSO
nufw(8)
nuauth(8)
AUTHOR
Nuauth was designed and coded by Eric Leblond, aka Regit (<eric@regit.org>) , and Vincent Deffontaines, aka gryzor (<vincent@gryzor.com>).
Original idea in 2001, while working on NSM Ldap support.
This manual page was written by Eric Leblond and copyrighted by INL (2003-2005)
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 2 as
published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts and no Back-Cover Texts.
12 mars 2007 NUACLGEN(8)