07-20-2010
Comparing fields in 1 file to another file
Need help with doing field comparisons.
File1
204.11.23.1 fastmovie.mp4
209.13.1.1 slowmovie.mp4
file 2
NY USA 201.1.1.1 200 freemovie.mp4
CA USA 204.11.23.1 404 notfastmovie.mp4
CA USA 204.11.23.1 200 fastmovie.mp4
basically need to take the first file and find exact matches in field 3 and 5 of the second file and I would print the entire line from file 2. So the output here would only be line 3 of file 2
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear Members,
I need a perl code:
1. Which will open first file with two columns separated by tab:
37 Distribution and seasonal variation of trace metals
85 Seasonal variability of the mixed layer in the central Bay
99 Dynamics of transparent exopolymeric particles (TEP)
103 Bacterial... (0 Replies)
Discussion started by: srsahu75
0 Replies
2. Shell Programming and Scripting
Help needed...
Can you tell me how to compare the last two couple entries in a file and print their result in new file..:confused:
I have one file
Check1.txt
\abc1 12345
\abc2 12327
\abc1 12345
\abc2 12330
I want to compare the entries in Check1 and write to... (1 Reply)
Discussion started by: kichu
1 Replies
3. Shell Programming and Scripting
I have a file having records like below
Field1;Filed2;Filed3
< '393200103052';'H3G';'20081204'
< '393200103059';'TIM';'20110111'
< '393200103061';'TIM';'20060206'
< '393200103064';'OPI';'20110623'
> '393200103052';'HKG';'20081204'
> '393200103056';'TIM';'20110111'
>... (5 Replies)
Discussion started by: shruthi123
5 Replies
4. Shell Programming and Scripting
Hi,
I have two files with below data::
file1:-
123|aaa|ppp
445|fff|yyy
999|ttt|jjj
555|hhh|hhh
file2:-
445|fff|yyy
555|hhh|hhh
The records present in file1, not present in file 2 should be writtent to the out put file.
output:-
123|aaa|ppp
999|ttt|jjj
Is there any one line... (3 Replies)
Discussion started by: gani_85
3 Replies
5. UNIX for Dummies Questions & Answers
Hello,
I have to write a script to compare the sum of the amount fields in a source file and the amount field in another file.
details are:
based on the name of the source file (say SALES as an example), a file already available in a path will be grabbed (say SALES_ParmFile) and this file... (4 Replies)
Discussion started by: vijaylak
4 Replies
6. Shell Programming and Scripting
Hi All,
I want to remove the rows from File1.csv by comparing the columns/fields in the File2.csv. I only need the records whose first column is same and the second column is different for the same record in both files.Here is an example on what I need.
File1.csv:
RAJAK|ACTIVE|1... (2 Replies)
Discussion started by: rajak.net
2 Replies
7. Shell Programming and Scripting
Hello all,
I need to write a script which has following requirement:
Need to read the filenames from text file and then search for the above read files in the required directory and if match found backup them in a backup folder.
And also need to compare and verify whether the files in the... (7 Replies)
Discussion started by: saurau
7 Replies
8. Shell Programming and Scripting
Hi All,
I am looking for an awk script to do the following
Join the fields together only if the first 4 fields are same.
Can it be done with join function in awk??
a,b,c,d,8,,,
a,b,c,d,,7,,
a,b,c,d,,,9,
a,b,p,e,8,,,
a.b,p,e,,9,,
a,b,p,z,,,,9
a,b,p,z,,8,,
desired output:
... (1 Reply)
Discussion started by: aksijain
1 Replies
9. Shell Programming and Scripting
I want to compare 2 files, locus_file.txt is a very large file and attr.txt is a small file. I want to match the first 2 columns of the first file to the second column of attr.txt and print the attributes together.
locus_file.txt:large file
LOC_Os02g47020, LOC_Os03g57840,0.88725114... (3 Replies)
Discussion started by: Sanchari
3 Replies
10. Shell Programming and Scripting
Hi,
file1.txt
AAA
BBB
CCC
DDD
file2.txt
abc|AAA|AAAabcbcs|fnwufnq
bca|nwruqf|AAA|fwfwwefwef
fmimwe|BBB|fnqwufw|wufbqw
wcdbi|CCC|wefnwin|wfwwf
DDD|wabvfav|wqef|fwbwqfwfe
i need the count of rows of file1.txt present in the file2.txt
required output:
AAA 2 (10 Replies)
Discussion started by: mdkm
10 Replies
LEARN ABOUT V7
pts_listentries
PTS_LISTENTRIES(1) AFS Command Reference PTS_LISTENTRIES(1)
NAME
pts_listentries - Displays all users or groups in the Protection Database
SYNOPSIS
pts listentries [-users] [-groups] [-cell <cell name>]
[-noauth] [-localauth] [-force] [-help]
pts liste [-u] [-g] [-c <cell name>] [-n] [-l]
[-f] [-h]
DESCRIPTION
The pts listentries command displays the name and AFS ID of all Protection Database entries of the indicated type. It also displays the AFS
ID of each entry's owner and creator.
To display all user and machine entries, either include the -users flag or omit both it and the -groups flag. To display all group
entries, include the -groups flag. To display all entries, provide both flags.
OPTIONS
-users
Displays user and machine entries.
-groups
Displays group entries.
-cell <cell name>
Names the cell in which to run the command. For more details, see pts(1).
-force
Enables the command to continue executing as far as possible when errors or other problems occur, rather than halting execution at the
first error.
-help
Prints the online help for this command. All other valid options are ignored.
-localauth
Constructs a server ticket using a key from the local /etc/openafs/server/KeyFile file. Do not combine this flag with the -cell or
-noauth options. For more details, see pts(1).
-noauth
Assigns the unprivileged identity anonymous to the issuer. For more details, see pts(1).
OUTPUT
The output includes a line for each entry, with information in four columns that have the following headers:
Name
The entry's name.
ID The entry's AFS ID (AFS UID for a user or machine, negative AFS GID for a group).
Owner
The AFS ID of the user or group that owns the entry.
Creator
The AFS ID of the user who created the entry (the system:administrators group is listed as the creator of the entry for "anonymous" and
the system groups, but it is not otherwise possible for a group to create groups).
In general, the entries appear in the order in which they were created.
EXAMPLES
The following example displays both user and group entries.
% pts listentries -users -groups
Name ID Owner Creator
system:administrators -204 -204 -204
system:anyuser -101 -204 -204
system:authuser -102 -204 -204
anonymous 32766 -204 -204
admin 1 -204 32766
pat 100 -204 1
smith 101 -204 1
pat:friends -206 100 100
staff -207 -204 1
PRIVILEGE REQUIRED
The issuer must belong to the system:administrators group.
SEE ALSO
pts(1), pts_creategroup(1), pts_createuser(1), pts_examine(1)
COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.
This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas
Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.
OpenAFS 2014-04-08 PTS_LISTENTRIES(1)