select distinct row from a file

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Select distinct sequences from fasta file and list

Hi How can I extract sequences from a fasta file with respect a certain criteria? The beginning of my file (containing in total more than 1000 sequences) looks like this: >H8V34IS02I59VP SDACNDLTIALLQIAREVRVCNPTFSFRWHPQVKDEVMRECFDCIRQGLG YPSMRNDPILIANCMNWHGHPLEEARQWVHQACMSPCPSTKHGFQPFRMA...

2. Shell Programming and Scripting

Select row from file and text

Hi all! I would like to solve a problem but I have no clue of how do it!I will be grateful if someone could help me! Briefly I have a big file like this: >ENSMUSG00000000204 | ENSMUST00000159637 GGCGAGGCTTACGCCATTTTACCTCAGCGAGCATTCATAAAGCTGCGAGCATTCATACAG >ENSMUSG00000000204 |...

3. Shell Programming and Scripting

How to find DISTINCT rows and combine in one row?

Hi , i need to display only one of duplicated values and merged them in one record only when tag started with 3100.2.128.8 3100.2.97.1=192.168.0.12 3100.2.128.8=418/66/03e9/0044801 3100.2.128.8=418/66/03ea/0044601 3100.2.128.8=418/66/03e9/0044801 3100.2.128.8=418/66/03ea/0044601...

4. Shell Programming and Scripting

Select distinct rows in a file by last column

Hi, I have the following file: LOG:015608::ERR:2310:map_spsrec:Invalid parameter LOG:015608::ERR:2471:map_dgdrec:Invalid parameter LOG:015608::ERR:2487:map_nnmrec:Invalid number LOG:015608::ERR:2310:map_nmrec:Invalid number LOG:015608::ERR:2438:map_nmrec:Invalid number As a delimiter I...

5. UNIX for Dummies Questions & Answers

Select 2 columns and transpose row by row

Hi, I have a tab-delimited file as follows: 1 1 2 2 3 3 4 4 a a b b c c d d 5 5 6 6 7 7 8 8 e e f f g g h h 9 9 10 10 11 11 12 12 i i j j k k l l 13 13 14 14 15 15 16 16 m m n n o o p p The output I need is: 1 1 a a 5 5 e e 9 9 i i 13...

6. Shell Programming and Scripting

select always the first row

Hi, I have an output like this: #CMD Output: user1 user2 user3 user4 How can I select ONLY the first row? Thanks

7. Shell Programming and Scripting

To count distinct fields in a row

I have . dat file which contains data in a specific format: 0 3 892 921 342 1 3 921 342 543 2 4 817 562 718 765 3 3 819 562 717 761 i need to compare each field in a row with another field of the same column but different row and cont the...

8. Programming

Select several minimum values from row (MySQL)

Hello there. I've got the query like that SELECT count(tour_id) AS cnt FROM orders JOIN tours ON orders.tour_id=tours.id GROUP BY tour_id The result Is cnt 1 4 2 1 1 Now i have to select all records with minimum values in field "cnt" MySQL function min() returns only one....

9. Shell Programming and Scripting

Select distinct values from a flat file

Hi , I have a similar problem. Please can anyone help me with a shell script or a perl. I have a flat file like this fruit country apple germany apple india banana pakistan banana saudi mango india I want to get a output like fruit country apple ...

10. UNIX for Dummies Questions & Answers

Select Distinct on multiple fields

How do I create a script that provides a count of distinct values of a particular field in a file utilizing commonly available UNIX commands (sh or awk)? Field1|Field2|Field3|Field4 AAA|BBB|CCC|DDD 111|222|333|777 AAA|EEE|ZZZ|EEE 111|555|333|444 AAA|EEE|CCC|DDD 111|222|555|444 For...

LEARN ABOUT DEBIAN

alzabo::runtime::joincursor

Alzabo::Runtime::JoinCursor(3pm)			User Contributed Perl Documentation			  Alzabo::Runtime::JoinCursor(3pm)

NAME

       Alzabo::Runtime::JoinCursor - Cursor that returns arrays of "Alzabo::Runtime::Row" objects

SYNOPSIS

	 use Alzabo::Runtime::JoinCursor;

	 my $cursor = $schema->join( tables => [ $foo, $bar ],
				     where => [ $foo->column('foo_id'), '=', 1 ] );

	 while ( my @rows = $cursor->next )
	 {
	     print $rows[0]->select('foo'), "
";
	     print $rows[1]->select('bar'), "
";
	 }

DESCRIPTION

       Objects in this class are used to return arrays of Alzabo::Runtime::Row objects when requested.	The cursor does not preload objects but
       rather creates them on demand, which is much more efficient.  For more details on the rational please see the RATIONALE FOR CURSORS section
       in Alzabo::Design.

INHERITS FROM

       "Alzabo::Runtime::Cursor"

METHODS

       next

       Returns the next array of "Alzabo::Runtime::Row" objects or an empty list if no more are available.

       If an individual row could not be fetched, then the array may contain some "undef" values.  For outer joins, this is normal behavior, but
       for regular joins, this probably indicates a data error.

       all_rows

       This method fetches all the rows available from the current point onwards.  This means that if there are five set of rows that will be
       returned when the object is created and you call "next()" twice, calling "all_rows()" after it will only return three sets.

       The return value is an array of array references.  Each of these references represents a single set of rows as they would be returned from
       the "next" method.

       reset

       Resets the cursor so that the next "next()" call will return the first row of the set.

       count

       Returns the number of rowsets returned by the cursor so far.

       next_as_hash

       Returns the next rows in a hash, where the hash keys are the table names and the hash values are the row object.  If a table has been
       included in the join via an outer join, then it is only included in the hash if there is a row for that table.

AUTHOR

       Dave Rolsky, <autarch@urth.org>

perl v5.8.8							    2007-12-23					  Alzabo::Runtime::JoinCursor(3pm)

UNIX for Dummies Questions & Answers