03-21-2009
merge two files into one file use awk
Hi, guys. I have one question:
I have two files: passwd and shadow (the number of records in these files are not equal)the contents of them are below:
passwd:
**************
ftp:x:24:24:
sshd:x:71:65:
uucp:x:10:14:
brownj:x:5005:1000:
sherrys: x :5006:1000:
...
*************
passwd:
**************
...
ftp:*:13503::
uucp:*:13503::
brownj:ASDFASERE#$#s:0:0
sherrys:GAS3434f#$#$@4:0:0
...
*****************
I want to merge them into a file or a variable called "join", which should have the following contents:
***************
...
ftp:24:*
uucp:10:*
brownj:5005:ASDFASERE#$#s
sherrys:5006:GAS3434f#$#$@4
...
***********************
How can I do this?
Thank you very much for your time in advance
-Keyang
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Guys,
I wonder whether is possible to merge two files using awk. I have two files one with 7 columns and another one with 9 columns and the first column on both files is identical so will be my key to merge the files. Any ideas.Thanks in advance.
Harby. (2 Replies)
Discussion started by: hariza
2 Replies
2. Shell Programming and Scripting
hi,
i am facing a problem in merging two files using awk,
the problem is as stated below,
file1:
A|B|C|D|E|F|G|H|I|1
M|N|O|P|Q|R|S|T|U|2
AA|BB|CC|DD|EE|FF|GG|HH|II|1
....
....
....
file2 :
1|Mn|op|qr (2 Replies)
Discussion started by: shashi1982
2 Replies
3. Shell Programming and Scripting
I have 2 files pipe delimted and want to merge them based on a key
e.g file 1
123$aaa$yyy$zzz
345$xab$yzy$zyz
456$sss$ttt$foo
799$aaa$ggg$dee
file 2
123$hhh
345$ddd
456$xxx
888$zzz
so if the key is the first field, and the result should be the common key between file 1 and 2 (6 Replies)
Discussion started by: loloAix
6 Replies
4. Shell Programming and Scripting
I want to merge data from 2nd file to 1st file based on 1st column
File1
====
data1,12,comp1
data1,13,comp2
data3,14,,
File2
====
data1,11,host1,lit
data2,11,host2,lit3
data3,11,host3,lit4
Required Ouput (5 Replies)
Discussion started by: greycells
5 Replies
5. UNIX for Dummies Questions & Answers
Dear programmers,
I have a question about conditionally merging multiple files and having their file names in the first column.
Input files:
file.1.extension file.2.extension file.3.extension file.4.extension ... file.1000.extension
where each file looks like this (with multiple lines):... (5 Replies)
Discussion started by: wei.deng
5 Replies
6. Shell Programming and Scripting
I have two file like follows. I want to merge them according the first field of file1. The separator of file1 is tab, while the second one is ",". I tried some code, but can't get the results.
File1:
AABB 6072 28 5922
BBCC 316 147 162
CCDD 907 71 231
File2:
CCDD,hTRBV12-4,hTRBJ2-3,319895... (7 Replies)
Discussion started by: xshang
7 Replies
7. Shell Programming and Scripting
Dear Awk experts!
I have been trying to get a one liner for a match and merge operation, but having difficulties as I'm an awk newb. I always get stuck on the match and merge with 2 files.
I have 2 files as follows:
File 1:
field 1,field 2,field 3,field 4,field 5,field 6,field 7,field... (6 Replies)
Discussion started by: landossa
6 Replies
8. Shell Programming and Scripting
file1
AAA3:WWW1:DDD1:XXX8:DDD2:XXX9
AAA6:WWW2:FFF1:XXX130:FFF1:XXX104:FFF1:XXX16
AAA7:WWW3:ZZZ1:XXX4:ZZZ2:XXX5:ZZZ3:XXX6:ZZZ4:XXX7file2
XXX8:EEE1:EEE2
XXX9:KKK1:KKK2
XXX130:OOO1:OOO2
XXX104:PPP1:PPP2
XXX16:RRR1:RRR1
XXX4:UUU1:UUU2
XXX5:III1:III2
XXX7:JJJ1:JJJ2Result... (2 Replies)
Discussion started by: vikus
2 Replies
9. Shell Programming and Scripting
Hi,
i have two files like these:
FILE 1
00:0f:35:1b:0c:00 1402691094.750049000 00:0f:35:1b:0c:00 1402691087.474893000
44:d3:ca:fd:a2:08 1402691091.865127000
30:e4:db:c1:df:de 1402691090.192464000
FILE 2_
00:0F:35 Cisco Systems, Inc
30:E4:DB Cisco Systems, Inc
I need a file 3, that... (5 Replies)
Discussion started by: bertiko
5 Replies
10. Shell Programming and Scripting
I have two csv files : say a.csv, b.csv
a.csv looks like this :
property1,property2,100
property3,property4,200
In a.csv, the combination of column1 and column2 will be unique
b.csv looks like this
property1,property2, 300, t1
property1,property2, 400,t2
property3, property4,800,t1... (2 Replies)
Discussion started by: Lakshmikumari
2 Replies
uusched(1M) System Administration Commands uusched(1M)
NAME
uusched - uucp file transport program scheduler
SYNOPSIS
/usr/lib/uucp/uusched [-u debug-level] [-x debug-level]
DESCRIPTION
uusched is the uucp(1C) file transport scheduler. It is usually started by the daemon uudemon.hour that is started by cron(1M) from an
entry in user uucp's crontab file:
11,41 * * * * /etc/uucp/uucp/uudemon.hour
OPTIONS
The options are for debugging purposes only. debug-level is a number between 0 and 9. Higher numbers give more detailed debugging infor-
mation:
The following options are supported:
-u debug-level Passes the -u debug-level option uucico(1M) as -x debug-level.
-x debug-level Outputs debugging messages from uusched.
FILES
/etc/uucp/Devices
/etc/uucp/Permissions
/etc/uucp/Systems
/var/spool/locks/*
/var/spool/uucp/*
/var/spool/uucppublic/*
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWbnuu |
+-----------------------------+-----------------------------+
SEE ALSO
uucp(1C), uustat(1C), uux(1C), cron(1M), uucico(1M), attributes(5)
SunOS 5.10 19 May 1993 uusched(1M)