Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: compare file columns
Top Forums Shell Programming and Scripting compare file columns Post 302284228 by learnoutmore99 on Thursday 5th of February 2009 03:58:50 AM
Old 02-05-2009
Bug compare file columns
I need help in file comparision.

I have two files in below format:
FILE_A:
-------
COL1 COL2 COL3 COL4 COL5

FILE_B:
-------
COL1A COL1B COL1C COL1D COL1E

i want to compare for a for each row in FILE_A and FILE_B
COL1 of FILE_A with COL1B of FILE_B
COL3 of FILE_A with COL1E of FILE_B
COL5 of FILE_A with COL1C of FILE_B

and in case they are matching, print the column values COL1 COL2 COL3 from FILE_A into FILE_OK,
and if they do not match then print them into FILE_ERR.txt

for example
FILE_A:
-------
A B C D 1
E F G H 2
I J K L 3

FILE_B:
-------
X E 2 M G
Y A 1 O T
for above two files, first row column of FILE_A (COL1, COL3 and COL5) are matching with
2nd row columns COL1B, COL1E and COL1C respectively of FILE_B, but for second row in FILE_A
they are not matching (COL3 not matching with COL1E).
what is the fastest possible way to do it using awk (or otherwise) ?
if i read line by line, it takes a lot of time as each file contains 50k++ records

Thanks in advance
:-)
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Compare selected columns from a file and print difference

I have learned file comparison from my previous post here. Then, it is comparing the whole line. Now, i have a new problem. I have two files with 3 columns separated with a "|". What i want to do is to compare the second and third column of file 1, and the second and third column of file 2. And... (4 Replies)
Discussion started by: kingpeejay
4 Replies

2. Shell Programming and Scripting

compare two columns of different files and print the matching second file..

Hi, I have two tab separated files; file1: S.No ddi fi cu o/l t+ t- 1 0.5 0.6 o 0.1 0.2 2 0.2 0.3 l 0.3 0.4 3 0.5 0.8 l 0.1 0.6 ... (5 Replies)
Discussion started by: vasanth.vadalur
5 Replies

3. UNIX for Dummies Questions & Answers

To compare first two columns in an excel file

Hi All, i have a excel sheet with two columns as below. column1 column2 100 100 200 300 300 400 400 400 500 600 i need to compare the values these two columns and the output should be printed in the third column...if these values are equal the output should be green and if these... (2 Replies)
Discussion started by: arunmanas
2 Replies

4. Shell Programming and Scripting

script to compare two columns in a file

Dear everyone, I need any sort of shell script or perl script would do the following. I have a txt file as follows: ;Stretnumber Resident Resdient (not in file) 16 John Mary 16 Mary Parker 16 Nancy Smith 16 Mary John 18 Trey ... (5 Replies)
Discussion started by: sasharma
5 Replies

5. Shell Programming and Scripting

Compare Multiple Columns in one file

Hello guys, I am quite new to Shell Scripting and I need help for this I have a CSV file like this: Requisition,Order,RequisitionLineNumber,OrderLineNumber REQ1,Order1,1,1 REQ1,Order1,1,3 REQ2,Order2,1,5 Basically what I want to do is compare the first 3 fields If all 3 fields are the same... (5 Replies)
Discussion started by: jeffreybsu
5 Replies

6. Shell Programming and Scripting

Compare two date columns in same file

Hi All, Need to compare two date columns from the filname FinalDate.txt. My data's are like below D_OT_START D_EXP_STR Amount 1/3/2012 1/3/2012 5000 6/21/2011 6/25/2011 6000 2/28/2011 2/28/2011 7000 7/16/2010 8/16/2010 8000 7/14/2010 10/26/2010 9000 ... (3 Replies)
Discussion started by: suresh_target
3 Replies

7. Shell Programming and Scripting

Compare columns in a single file

i have the following files (all separated by tabs): file 1.txt 1 yes 2 no 3 yes 4 yes file 2.txt a no b no c yes d no i combine the above files in file 3 which looks like file 3.txt 1 yes a no 2 no b no 3 yes c yes 4 yes d no now, i need to compare the values between column 2... (3 Replies)
Discussion started by: msonoth
3 Replies

8. Shell Programming and Scripting

Compare 2 columns from the same file and print a value depending on the result

Hello Unix gurus, I have a file with this format (example values): label1 1 0 label2 1 0 label3 0.4 0.6 label4 0.5 0.5 label5 0.1 0.9 label6 0.9 0.1 in which: column 1 is a row label column 2 and 3 are values I would like to do a simple operation on this table and get the... (8 Replies)
Discussion started by: ksennin
8 Replies

9. UNIX for Beginners Questions & Answers

Compare two columns of one file to two columns in another file

I Have two files as below, first file: Start State |Next State |Session Count |Transition% LA_product_view |home |694 |28.660% LA_product_view | searchresults |54 |2.230% home | 1101260 | 2 | 0.050% second file: Start State Next State Session Count Transition% ... (7 Replies)
Discussion started by: Raghuram717
7 Replies

10. UNIX for Beginners Questions & Answers

Awk: compare values in two columns of the same file

I'm trying to learn awk, but I've hit a roadblock with this problem. I have a hierarchy stored in a file with 3 columns: id name parentID 4 D 2 2 B 1 3 C 1 1 A 5 I need to check if there are any values in column 3 that are not represented anywhere in column 1. I've tried this: awk '{arr;}... (7 Replies)
Discussion started by: kaktus
7 Replies

LEARN ABOUT REDHAT

ldap_compare_ext

LDAP_COMPARE(3) 					     Library Functions Manual						   LDAP_COMPARE(3)

NAME

       ldap_compare, ldap_compare_s - Perform an LDAP compare operation

SYNOPSIS

       #include <ldap.h>

       int ldap_compare_s(ld, dn, attr, value)
       LDAP *ld;
       char *dn, *attr, *value;

       int ldap_compare(ld, dn, attr, value)
       LDAP *ld;
       char *dn, *attr, *value;

DESCRIPTION

       The  ldap_compare_s()  routine  is used to perform an LDAP compare operation synchronously.  It takes dn, the DN of the entry upon which to
       perform the compare, and attr and value, the attribute type and value to compare to those found in the entry.  It  returns  an  LDAP  error
       code,  which  will  be  LDAP_COMPARE_TRUE if the entry contains the attribute value and LDAP_COMPARE_FALSE if it does not.  Otherwise, some
       error code is returned.

       The ldap_compare() routine is used to perform an LDAP compare operation asynchronously.	It takes the same parameters as  ldap_compare_s(),
       but returns the message id of the request it initiated.	The result of the compare can be obtained by a subsequent call to ldap_result(3).

ERRORS

       ldap_compare_s()  returns an LDAP error code which can be interpreted by calling one of ldap_perror(3) and friends.  ldap_compare() returns
       -1 if something went wrong initiating the request.  It returns the non-negative message id of the request if things went ok.

BUGS

       There is no way to compare binary values, but there should be.

SEE ALSO

       ldap(3), ldap_error(3)

ACKNOWLEDGEMENTS

       OpenLDAP is developed and maintained by The OpenLDAP Project (http://www.openldap.org/).  OpenLDAP is derived from University  of  Michigan
       LDAP 3.3 Release.

OpenLDAP 2.0.27-Release 					 22 September 1998						   LDAP_COMPARE(3)
All times are GMT -4. The time now is 08:08 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy