in reply to Comparing specific columns from 2 files

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

  • Comment on Re: Comparing specific columns from 2 files

In Section Seekers of Perl Wisdom