Any ideas are appreciated? My current code is to compare all columns between 2 files for exactness.

Write code to compare the columns instead?

diff column, compare column, ?node_id=3989;HIT=diff%20column;re=N,

Found 12 nodes roughly between 2015-07-29 and 1999-10-04 (searched 100.00% of DB).


where title contains all of "diff", "column"

Date:Author/owner:Title:Node type:
2013-12-03 Arun Kumar Difference in retrieving values from a varchar2 column and number column from DB SoPW
2013-10-01 nicopelle Compare 2 CSV files by two different column and printout SoPW
2011-02-15 Renyulb28 Remove row if the absolute difference between two columns is greater than a threshold SoPW
2011-01-19 Anonymous Monk Matching column in different files to create a third one SoPW
2010-11-30 vis1982 Keeping one colmun fixed and second column changed at different intervals to print the output SoPW
2010-10-26 sundeep Extract and read different columns from the file SoPW
2009-06-11 steph_bow writing results on two different columns on the same file SoPW
2008-11-14 zerocred find difference in dates/items in same column SoPW
2008-05-31 magawake Trying to parse columns with different delimiters. SoPW
2007-11-02 Anonymous Monk Perl/Html Question - rows are not aligned between different columns SoPW
2003-01-31 gisrob Printing Columns from Two Different Files SoPW
2003-01-23 Anonymous Monk how do i convert text file into a table having fixed columns and different rows SoPW

Found 8 nodes roughly between 2015-07-29 and 1999-10-04 (searched 100.00% of DB).


where title contains all of "compare", "column"

Date:Author/owner:Title:Node type:
2015-05-25 anonym Compare three columns of one file with three columns of another file in perl SoPW
2014-09-20 Anonymous Monk compare columns in all possible combination SoPW
2013-10-01 nicopelle Compare 2 CSV files by two different column and printout SoPW
2012-09-21 linseyr compare values while value on other column remains the same SoPW
2012-08-06 ejbiers compare two files by column and return second (matching) column SoPW
2009-09-30 BhariD how to compare column 1 to column 2 and vice versa from multiple rows. SoPW
2005-07-07 eyidearie Read a column; Compare strings for close (not exact) matches SoPW
2003-09-16 th3monk3y DBI compare columns problem SoPW

?node_id=3989;HIT=csv%20diff;re=N , ?node_id=3989;HIT=csv%20comp;re=N

Found 8 nodes roughly between 2015-07-29 and 1999-10-04 (searched 100.00% of DB).


where title contains all of "csv", "diff"

Date:Author/owner:Title:Node type:
2014-07-17 pavithravenky how to convert multiple xml files with different structure into CSV files SoPW
2013-10-01 nicopelle Compare 2 CSV files by two different column and printout SoPW
2013-03-04 tsk1979 Diff CSV files - But ignore certain fields SoPW
2011-08-07 foxycleop difficulty reading csv file SoPW
2009-06-24 bichonfrise74 Difference between Text::CSV_XS and Text::CSV SoPW
2005-11-01 BrowserUk [GOLF] Perl csv diff Obfu
2004-06-24 jZed CSV table diff utility Snippet
2004-06-22 Limbic~Region CSV Diff Utility SoPW

Found 20 nodes roughly between 2015-07-29 and 1999-10-04 (searched 100.00% of DB).


where title contains all of "csv", "comp"

Date:Author/owner:Title:Node type:
2015-05-03 PERL_fresher CSV files compare SoPW
2014-09-26 ray15 comparing csv files in perl SoPW
2014-08-27 scotttromley Parsing a complex csv, cleaning it up, and exporting it SoPW
2014-06-24 KIASohc Compare and group unmatched records from 2 CSV files together SoPW
2014-05-07 john.tm compare csv files only to first fullstop character SoPW
2013-10-01 nicopelle Compare 2 CSV files by two different column and printout SoPW
2012-07-02 slayedbylucifer Compare 2 CSV files and create a new CSV file out of comparision SoPW
2011-04-25 rmfin730 Help parsing a complicated csv SoPW
2009-06-05 mpaler complex text file to csv SoPW
2009-05-28 carlo1973 Comparing csv text file to mysql db in order to look for missing entries within the db. SoPW
2008-08-18 meredib Comparing 2 csv files SoPW
2008-02-27 tsk1979 CSV file reading and comparison SoPW
2006-07-19 Anonymous Monk Compare CSV files SoPW
2006-05-25 tgrossner Comparing fields of two CSV files SoPW
2006-01-19 boddeti compare records in two csv files SoPW
2005-12-13 eric256 Compare 2 csv files using a key set of colums CUFP
2004-12-08 jZed Benchmark comparison of Text::xSV and Text::CSV_XS Med
2004-10-14 benz Comparing CSV files SoPW
2004-06-14 jZed Comparison of the parsing features of CSV (and xSV) modules Med
2003-10-07 traveler Compare csv file fields? SoPW

In reply to Re: Comparing specific columns from 2 files by Anonymous Monk
in thread Comparing specific columns from 2 files by arunsriniv

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.