|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Compare a common field in two files and append a column from File 1 in File2
Post 302630523 by asterisk-ix_use on Thursday 26th of April 2012 01:06:46 AM
04-26-2012
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
... (4 Replies)
Discussion started by: manneni prakash
4 Replies
2. Shell Programming and Scripting
First, thanks for the help in previous posts... couldn't have gotten where I am now without it!
So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following:
If $1... (4 Replies)
Discussion started by: right_coaster
4 Replies
3. Shell Programming and Scripting
I have 2 zip files which have about 20 million records in each file. file 2 will have additional records than file 1. I want to compare the records in both the files and capture the new records from file 2 into another file file3. Please help me with a command/script which provides me the desired... (8 Replies)
Discussion started by: koneru
8 Replies
4. 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
5. Shell Programming and Scripting
- I have two files (File 1 and File 2) and the contents of the files are mentioned below.
- I am trying to compare the values of Column1 of File1 with Column1 of File2. If a match is found, print the corresponding value from Column2 of File1 in Column5 of File2.
- I tried to modify and use... (10 Replies)
Discussion started by: Santoshbn
10 Replies
6. Shell Programming and Scripting
Hi Friends,
Need Help. I have file1.txt as
File1.txt
|123|A|7267|Hyder|Cross|Sell|7801
|995|A|7051|2008|Lunar|New|Year|Promotion|7801
|996|A|7022|Q108|Targ|Prospect|&|SSCC|Savings|Promo|7801
|997|A|7182|Q1|Feb-Apr|08|Credit|ITA|PA|SBA|Campaign|7801
File2.txt... (7 Replies)
Discussion started by: i150371485
7 Replies
7. Shell Programming and Scripting
Hi Freinds,
I have 2 files . one is source.txt and second one is target.txt. I want to keep source.txt as baseline and compare target.txt. please find the data in 2 files and Expected output.
Source.txt
1|HYD|NAG|TRA|34.5|1234
2|CHE|ESW|DES|36.5|134
3|BAN|MEH|TRA|33.5|234... (5 Replies)
Discussion started by: i150371485
5 Replies
8. Shell Programming and Scripting
Good morning all,
I have a problem that is one step beyond a standard awk compare.
I would like to compare three files which have several thousand records against a fourth file. All of them have a value in each row that is identical, and one value in each of those rows which may be duplicated... (1 Reply)
Discussion started by: nashton
1 Replies
9. Shell Programming and Scripting
Hi
I have two files file1 and file2
File1 10,000 entries:It has 3 columns below.
conn=232257 client=xxx.xxx.xx.xxx:60491 protocol=LDAP
File2 has 500 entries It has two columns.
conn=232257 dn="uid=xxxx,ou=xxxx,ou=xxxx,dc=xxxxx,dc=xxxx"
conn=232398... (10 Replies)
Discussion started by: buzzme
10 Replies
10. UNIX for Beginners Questions & Answers
hi
I have 2 file with more than 10 columns for both
1st file
apple,0,0,0......
orange,1,2,3.....
mango,2,4,5.....
2nd file
apple,2,3,4,5,6,7...
orange,2,3,4,5,6,8...
watermerlon,2,3,4,5,6,abc...
mango,5,6,7,4,6,def.... (1 Reply)
Discussion started by: tententen
1 Replies
LEARN ABOUT HPUX
fs_wrapper
fs_wrapper(5) File Formats Manual fs_wrapper(5) NAME
fs_wrapper - configuration and binary files used by file system administration commands SYNOPSIS
FStype] ... FStype] ... FStype] ... FStype] ... FStype] ... FStype] ... FStype] ... FStype] ... FStype] ... FStype] ... FStype] ... DESCRIPTION
The commands listed in the SYNOPSIS can operate on different types of file systems. Each command (except for reads file system specific configuration files that control the command's behavior, and invokes a file system specific binary file to do the actual work. FStype is the file system type as optionally specified on the command line. If FStype is not given, then the file system type is determined from by matching an entry in this file with a device provided with the command (see individual commands for details of usage). Administrators may also define a default file system type for the above commands via the file If this file exists, and contains the line: (e.g., then the above commands will assume the FStype given in unless an FStype is provided on the command line or is in The default file system specification is provided to maintain compatibility with pre-10.0 invocations of the commands. See the FILES section for a list of the files used. WARNINGS
The configuration files are supplied by HP or by other file system vendors. They are not meant to be edited by System Administrators. Corruption or removal of these files may lead to strange behavior, including the inability to boot. The format of the configuration file is subject to change. The file system specific binary files are not normally executed directly. However, if the configuration files become unusable, direct exe- cution of these binary files may be a useful step in repairing and running the system again. The binary files accept the same arguments as the commands by which they are executed. The command is a special case. This command currently does not read a configuration file, and does not execute a file system specific binary file if FStype is or The binary that handles these FStypes also processes other FStypes and calls the file system specific command if appropriate. For historical reasons, the binary files also handle and so there are no separate binary files for the latter two file systems. The commands (except will not work if they are renamed, because they are symbolically linked to a single executable FILES
FStype is the file system type as optionally specified on the command line. command is the name of the command. File system specific binary files for the and commands. There may be additional file system specific binary files in this directory that are not associated with File system specific binary files for the remaining commands. There may also be other file system specific binary files in this directory that are not associated with Configuration files for each file system type. File in which the default file system type can be defined. If this file does not exist, there is no default file system type. Static information about the file systems SEE ALSO
ff(1M), fsck(1M), fsdb(1M), mkfs(1M), mount(1M), ncheck(1M), newfs(1M), quot(1M), quotacheck(1M), volcopy(1M), fstab(4). fs_wrapper(5)