07-31-2009
How to append two files with common field.
I have two files like
File1 : will get this file from "who" command. It is a unix file.
user val1 Jul 29 13:15 (IP Address1)
user val3 Jul 30 03:21 (IP Address2)
user val2 Jul 29 13:16 (IP Address3)
user val4 Jul 29 13:17 (IP Address4)
File2 : I will export the data from DATABASE with space as a delimiter. So this file is different from unix file
val1 id1 machine name
val2 id2 machine name
val4 id3 machine name
val3 id4 machine name
Question is:
I want to append 1st column of the first file to 2nd file by comparing (val1,val3,val2,val4) in the 1st file with (val1,val2,val4,val3) second file.
Please, Can anyone help in this.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Please help, I am new to shell Programming. I have three files each containg a unique text (key) field (e.g. ABCDEF, XCDUD as shown below), line return followed by some data of which there can be more then one instance. In addition, in some cases there may be no data but only a key field. Please... (18 Replies)
Discussion started by: gugs
18 Replies
2. Shell Programming and Scripting
I have 2 files with a common parm - Jobname
File 1
0507 1202 JOBA
0507 1302 JOBB
0507 1452 JOBC
0507 1552 JOBA
0507 1553 JOBA
File2
JOBA abcdefg server4
JOBB defghij server22
JOBC vwxyz12 server55
I would like to take each line from File1 and match the jobname with the jobname... (8 Replies)
Discussion started by: Northerner
8 Replies
3. 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
4. Shell Programming and Scripting
Hi experts,
Would you please help me with this?
I have several files and I need to join the forth field of them based on the common first field.
here's an example...
first file:
280346 39.88 -75.08 547.8
280690 39.23 -74.83 538.7
280729 40.83 -75.08 499.2
280907 40.9 -74.4 507.8... (5 Replies)
Discussion started by: GoldenFire
5 Replies
5. UNIX for Dummies Questions & Answers
I have two files in UNIX.
1st file is Entity and Second File is References. 1st File has only one column named Entity ID and 2nd file has two columns Entity ID | Person ID.
I want to produce a output file where entity id's are matching in both the files.
Entity File
624197
624252
624264... (4 Replies)
Discussion started by: PRS
4 Replies
6. Shell Programming and Scripting
Hi List,
I have two files. File1 contains all of the data I require to be processed, and I need to add another field to this data by matching a common field in File2 and appending a corresponding field to the data in File1 based on the match... So:
File 1:... (1 Reply)
Discussion started by: landossa
1 Replies
7. UNIX for Dummies Questions & Answers
file1:
Toronto:12439755:1076359:July 1, 1867:6
Quebec City:7560592:1542056:July 1, 1867:5
Halifax:938134:55284:July 1, 1867:4
Fredericton:751400:72908:July 1, 1867:3
Winnipeg:1170300:647797:July 15, 1870:7
Victoria:4168123:944735:July 20, 1871:10
Charlottetown:137900:5660:July 1, 1873:2... (2 Replies)
Discussion started by: mindfreak
2 Replies
8. Shell Programming and Scripting
Hi Friends,
I am new to Shell Scripting and need your help in the below situation.
- I have two files (File 1 and File 2) and the contents of the files are mentioned below.
- "Application handle" is the common field in both the files.
(NOTE :- PLEASE REFER TO THE ATTACHMENT "Compare files... (2 Replies)
Discussion started by: Santoshbn
2 Replies
9. UNIX for Dummies Questions & Answers
Hi all !
I almost did it but got a small problem.
input:
cars red
cars blue
cars green
truck black
Wanted:
cars red-blue-green
truck black
Attempt:
gawk 'BEGIN{FS="\t"}{a = a (a?"-":"")$2; $2=a; print $1 FS $2}' input
But I also got the intermediate records... (2 Replies)
Discussion started by: beca123456
2 Replies
10. UNIX for Beginners Questions & Answers
Hi,
A beginner one.
my input.tab (tab-separated):
h1 h2 h3 h4 h5
item1 grpA 2 3 customer1
item2 grpB 4 6 customer1
item3 grpA 5 9 customer1
item4 grpA 0 0 customer2
item5 grpA 9 1 customer2
objective:
output a file for each customer ($5) with the item number ($1) only if $2 matches... (2 Replies)
Discussion started by: beca123456
2 Replies
LEARN ABOUT CENTOS
lnewusers
lnewusers(1) General Commands Manual lnewusers(1)
NAME
lnewusers - Create new user accounts
SYNOPSIS
lnewusers [OPTION]...
DESCRIPTION
Creates new user accounts using data read from standard input.
The input data consists of lines, each line has 7 colon-separated fields:
User name
Plaintext password
User ID
lnewusers refuses to create users with user ID 0 (the root user ID).
Group If this field is a valid group ID, it is interpreted as a group ID, otherwise as a group name. If the field is empty, a group name
equal to user name is used.
If the specified group does not exist, it is automatically created. If the group is specified with a group ID, the created group
has group name equal to the user name.
GECOS The GECOS field is traditionally used to store user's real name and other information.
Home directory
If this field is empty, a default specified by libuser configuration, or /home/username if libuser configuration does not specify a
default, is used.
Login shell
If this field is empty, a default specified by libuser configuration is used.
Errors in user specifications are reported and processing continues on the next line.
OPTIONS
-f, --file=file
Read account data from file instead of standard input.
-i, --interactive
Ask all questions when connecting to the user database, even if default answers are set up in libuser configuration.
-M, --nocreatehome
Don't create home directories.
-n, --nocreatemail
Don't create mail spool files.
EXIT STATUS
The exit status is 0 on success, nonzero on fatal error. Errors in user specifications are not reflected in the exit status.
libuser Jul 13 2008 lnewusers(1)