Need urgent help in comparing two fields in two files

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Comparing two files by two matching fields

Long time listener first time poster. Hope someone can advise. I have two files, 1000+ lines in each, two fields in each file. After performing a sort, what is the best way to find exact matches where field $1 and $2 in file1 are also present in file2 on the same line, then output only those...

2. Shell Programming and Scripting

Comparing two files using four fields

Dear All, I want to compare File1 and File2 (Separated by spaces) using four fields (Column 1,2,4,5). Logic: If column 1 and 2 of File1 and File2 match exactly and if the File2 has the same characters as any of the characters present in column 4 and 5 of file1 then those lines of file1 and file2...

3. Shell Programming and Scripting

Comparing two files using four fields

I want to compare File1 and File2 (Separated by spaces) using four fields (Column 1,2,4,5). Logic: If column 1 and 2 of File1 and File2 match exactly and if the File2 has the same characters as any of the characters present in column 4 and 5 of file1 then those lines of file1 and file2 are...

4. Shell Programming and Scripting

comparing two files for matching fields

I am newbie to unix and would please like some help to solve the task below I have two files, file_a.text and file_b.text that I want to evaluate. file_a.text 1698.74 1711.88 6576.25 899.41 3205.63 4187.98 697.35 1551.83 ...

5. Programming

comparing two fields from two different files in AWK

Hi, I have two files formatted as following: File 1: (user_num_ID , realID) (the NR here is 41671) 1 cust_034_60 2 cust_80_91 3 cust_406_4 .. .. File 2: (realID , clusterNumber) (total NR here is 1000) cust_034_60 2 cust_406_4 3 .. ..

6. Shell Programming and Scripting

Problem in comparing 2 fields from 2 files

I've 2 files. Need to compare File1.Field1,File1.Field2 with File2.Field1,File2.Field2. If matches then create a new file. File1 10 A|ADB|967143.24|1006101.5 3E HK|DHB|24294.76|242513.89 ABN ACU|ADB|22104.69|51647.14 ABN BU|DBA|39137.14|109128.38 ABN|ADB|64466.89|167936.55 ABOC...

7. Shell Programming and Scripting

Comparing two files and inserting new fields

Hi all, I searched the forum and tried to learn from the similar posts. However, I am new and I need to get help on this. I hope an expert kindly help me to sort this out. I need to compare field 1 and 2 of the first file with the same fields of the second file and if both fields matches...

8. Shell Programming and Scripting

Comparing fields in two files

Hi, i want to compare two files by one field say $3 in file1 needs to compare with $2 in file2. sample file1 - reqd_charge_code 2263881188,24570896,439 2263881964,24339077,439 2263883220,22619162,228 2263884224,24631840,442 2263884246,22612161,442 sample file2 - rg_j ...

9. Shell Programming and Scripting

Comparing two files and replacing fields

I have two files with ids and email addresses. File 2 cotains a subset of the records in file 1. The key field is the first field containing the id. file 1: 123|myadr@abc.com 456|myadr2@abc.com 789|myadr3@abc.com file 2: 456|adr456@xyz.com Where the record appears in the second...

10. Shell Programming and Scripting

Merging two files by comparing three fields

Hi Experts, I need your timely help. I have a problem with merging two files. Here my situation : Here I have to compare first three fields from FILE1 with FILE2. If they are equal, I have to append the remaining values from FILE2 with FILE1 to create the output. FILE1: Class ...

LEARN ABOUT LINUX

active

ACTIVE(5)                                                       File Formats Manual                                                      ACTIVE(5)

NAME

       active, active.times - list of active Usenet newsgroups

DESCRIPTION

       The  file  /var/lib/news/active  lists  the newsgroups that the local site receives.  Each newsgroup should be listed only once.  Each line
       specifies one group; their order in the file does not matter.  Within each newsgroup, articles are assigned unique names, which  are  mono-
       tonically increasing numbers.

       If  an article is posted to newsgroups not mentioned in this file, those newsgroups are ignored.  If no valid newsgroups are specified, the
       article is filed into the newsgroup ``junk'' and only propagated to sites that receive the ``junk'' newsgroup.

       Each line consists of four fields specified by a space:

                      name himark lomark flags

       The first field is the name of the newsgroup.  The second field is the highest article number that has been used in  that  newsgroup.   The
       third field is the lowest article number in the group; this number is not guaranteed to be accurate, and should only be taken to be a hint.
       Note that because of article cancellations, there may be gaps in the numbering sequence.  If the lowest article number is greater then  the
       highest  article  number,  then  there  are no articles in the newsgroup.  In order to make it possible to update an entry in-place without
       rewriting the entire file, the second and third fields are padded out with leading zeros to make them a fixed width.

       The fourth field can contain one of the following flags:

              y        Local postings are allowed
              n        No local postings are allowed, only remote ones
              m        The group is moderated and all postings must be approved
              j        Articles in this group are not kept, but only passed on
              x        Articles cannot be posted to this newsgroup
              =foo.bar Articles are locally filed into the ``foo.bar'' group

       If a newsgroup has the ``j'' flag, then no articles will be filed into that newsgroup and local postings to that group should not be gener-
       ated.   If an article for such a newsgroup is received from a remote site, it will be filed into the ``junk'' newsgroup if it is not cross-
       posted.  This is different from not having a newsgroup listed in the file because sites can subscribe to ``j'' newsgroups and  the  article
       will be propagated to them.

       If  the  fourth  field  of a newsgroup starts with an equal sign, then the newsgroup is an alias.  Articles can be posted to the group, but
       will be treated as if they were posted to the group named after the equal sign.  The second and third fields are ignored.   Note  that  the
       Newsgroup  header  is  not  modified  (Alias groups are typically used during a transition, and are typically created with ctlinnd(8)).  An
       alias newsgroup should not point to another alias.

       The file /var/lib/news/active.times provides a chronological record of when newsgroups are created.   This  file  is  normally  updated  by
       innd(8) whenever a ctlinnd ``newgroup'' command is done.  Each line consist of three fields:

              name time creator

       The  first  field  is the name of the newsgroup.  The second field is the time it was created, expressed as the number of seconds since the
       epoch -- i.e., a time_t; see gettimeofday(2).  The third field is the electronic mail address of the person who created the group.

HISTORY

       Written by Rich $alz <rsalz@uunet.uu.net> for InterNetNews.  This is revision 1.13, dated 1996/10/29.

SEE ALSO

       ctlinnd(8), innd(8).

                                                                                                                                         ACTIVE(5)

UNIX for Advanced & Expert Users