Comparing 2 files and return the unique lines in first file Post: 302281052

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

comparing 2 text files to get unique values??

Hi all, I have got a problem while comparing 2 text files and the result should contains the unique values(Non repeatable). For eg: file1.txt 1 2 3 4 file2.txt 2 3 So after comaping the above 2 files I should get only 1 and 4 as the output. Pls help me out.

2. Shell Programming and Scripting

return a list of unique values of a column from csv format file

Hi all, I have a huge csv file with the following format of data, Num SNPs, 549997 Total SNPs,555352 Num Samples, 157 SNP, SampleID, Allele1, Allele2 A001,AB1,A,A A002,AB1,A,A A003,AB1,A,A ... ... ... I would like to write out a list of unique SNP (column 1). Could you...

3. UNIX for Dummies Questions & Answers

Getting non unique lines from concatenated files

Hi All, Is there a way to get NON unique lines from 2 or more concatenated files? Basically I have several files which are very similar with the exception of few lines and I want to find out which lines are different in each file. Very simple example is file1 contains: 1 2 3 4 5file2...

4. UNIX for Advanced & Expert Users

In a huge file, Delete duplicate lines leaving unique lines

Hi All, I have a very huge file (4GB) which has duplicate lines. I want to delete duplicate lines leaving unique lines. Sort, uniq, awk '!x++' are not working as its running out of buffer space. I dont know if this works : I want to read each line of the File in a For Loop, and want to...

5. Shell Programming and Scripting

Comparing files and capture return code

Hi, I would like to compare 2 files, and have a return code write to a file. regardless of the files contents are the same the code should be writing to a file (if both files contents are same then return code 0). A simple example will be great :) Thanks

6. UNIX for Dummies Questions & Answers

getting unique lines from 2 files

hi i have used comm -13 <(sort 1.txt) <(sort 2.txt) option to get the unique lines that are present in file 2 but not in file 1. but some how i am getting the entire file 2. i would expect few but not all uncommon lines fro my dat. is there anything wrong with the way i used the command? my...

7. Shell Programming and Scripting

compare 2 files and return unique lines in each file (based on condition)

hi my problem is little complicated one. i have 2 files which appear like this file 1 abbsss:aa:22:34:as akl abc 1234 mkilll:as:ss:23:qs asc abc 0987 mlopii:cd:wq:24:as asd abc 7866 file2 lkoaa:as:24:32:sa alk abc 3245 lkmo:as:34:43:qs qsa abc 0987 kloia:ds:45:56:sa acq abc 7805 i...

8. Shell Programming and Scripting

Comparing 2 text files & downloading a file if the last lines are different

Hello I'm having a little difficulty in writing a shell script for a few simple tasks. First I have two files "file1.txt" and "file2.txt" and I want to read and compare the last line of each file. The files look like this. File1.txt File2.txt After comparing the two lines I would...

9. Shell Programming and Scripting

Using grep and a parameter file to return unique values

Hello Everyone! I have updated the first post so that my intentions are easier to understand, and also attached sample files (post #18). I have over 500 text files in a directory. Over 1 GB of data. The data in those files is organised in lines: My intention is to return one line per...

10. Shell Programming and Scripting

Shell Scripting | Return list of unique characters in files

Hi, I am trying to script the below, but I am not very good at it :( Your help would be greatly appreciated. 1. read all files in the directory in strings strings *.* 2. in each file, for each line that contains "ABCD", store characters located at position 521 and 522 of this line...

LEARN ABOUT DEBIAN

spreadsheet::parseexcel::simple

Spreadsheet::ParseExcel::Simple(3pm)			User Contributed Perl Documentation		      Spreadsheet::ParseExcel::Simple(3pm)

NAME

       Spreadsheet::ParseExcel::Simple - A simple interface to Excel data

SYNOPSIS

	 my $xls = Spreadsheet::ParseExcel::Simple->read('spreadsheet.xls');
	 foreach my $sheet ($xls->sheets) {
	    while ($sheet->has_data) {
		my @data = $sheet->next_row;
	    }
	 }

DESCRIPTION

       This provides an abstraction to the Spreadsheet::ParseExcel module for simple reading of values.

       You simply loop over the sheets, and fetch rows to arrays.

       For anything more complex, you probably want to use Spreadsheet::ParseExcel directly.

BOOK METHODS

       read

	 my $xls = Spreadsheet::ParseExcel::Simple->read('spreadsheet.xls');

       This opens the spreadsheet specified for you. Returns undef if we cannot read the book.

       sheets

	 @sheets = $xls->sheets;

       Each spreadsheet can contain one or more worksheets. This fetches them all back. You can then iterate over them, or jump straight to the
       one you wish to play with.

       book

	       my $book = $xls->book;

       The Spreadsheet::ParseExcel object we are working with. You can use this if you need to manipulate it in ways that this interface doesn't
       allow.

SHEET METHODS

       These methods can be called on each sheet returned from $xls->sheets:

       has_data

	 if ($sheet->has_data) { ... }

       This lets us know if there are more rows in this sheet that we haven't read yet. This allows us to differentiate between an empty row, and
       the end of the sheet.

       next_row

	 my @data = $sheet->next_row;

       Fetch the next row of data back.

       sheet

	       my $obj = $sheet->sheet;

       The underlying Spreadsheet::ParseExcel object for the worksheet. You can use this if you need to manipulate it in ways that this interface
       doesn't allow (e.g. asking it for the sheet's name).

AUTHOR

       Tony Bowden

BUGS and QUERIES
       Please direct all correspondence regarding this module to:
	 bug-Spreadsheet-ParseExcel-Simple@rt.cpan.org

COPYRIGHT AND LICENSE

	 Copyright (C) 2001-2005 Tony Bowden.

	 This program is free software; you can redistribute it and/or modify it under
	 the terms of the GNU General Public License; either version 2 of the License,
	 or (at your option) any later version.

	 This program is distributed in the hope that it will be useful, but WITHOUT
	 ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
	 FOR A PARTICULAR PURPOSE.

SEE ALSO

       Spreadsheet::ParseExcel.

perl v5.8.8							    2008-03-12				      Spreadsheet::ParseExcel::Simple(3pm)