select distinct row from a file Post: 70686

10 More Discussions You Might Find Interesting

1. 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...

2. 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 ...

3. 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....

4. 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...

5. 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

6. 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...

7. 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...

8. 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...

9. 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 |...

10. 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...

LEARN ABOUT DEBIAN

svn-do

SVN-DO(1)							 Command reference							 SVN-DO(1)

NAME

       svn-do - export a source and run a command inside the source.

SYNOPSIS

       svn-do COMMAND

DESCRIPTION

       svn-do will use svn-buildpackage to export a source, run a command inside the exported source and, if the command succeeds, copy back the
       debian/ tree

EXAMPLES

       clean the tree (useful if this requires the full source tree)

	   $ svn-do debclean
	   I: Exporting source tree via svn-buildpackage...
	   [...]
	   I: Running command: debclean
	   [...]
	   I: Copying back the debian/ tree...
	   'debian/control' -> 'path/package/debian/control'

       use quilt to refresh a patch

	   $ QUILT_PATCHES=debian/patches svn-do 
	    sh -c "quilt push 002_static-linking-dont-build-perf.patch; 
	    quilt refresh"
	   [...]
	   I: Copying back the debian/ tree...
	   [...]
	   'debian/patches/002_static-linking-dont-build-perf.patch' ->
	   '/path/package/debian/patches/002_static-linking-dont-build-perf.patch'

       Start a source editing session and decide later not to copy back the debian/ tree

	   $ svn-do $SHELL
	   [...]
	   I: Running command: /bin/zsh
	   % exit 1
	   E: command exited with 1; not copying back the debian/ tree.

       edit a patch in a CDBS' simple-patchsys based package

	   $ svn-do cdbs-edit-patch 02_pmount.patch
	   [...]

SEE ALSO

       /usr/share/doc/svn-buildpackage/()
	   The svn-buildpackage HOWTO manual

       svn-inject(1)
	   puts a Debian source package into Subversion repository

       svn-upgrade(1)
	   upgrade source package from a new upstream revision

       svn(1)
	   Subversion command line client tool

       dpkg-buildpackage(1)
	   Debian source package tools

       lintian(1)
	   Debian package checker

AUTHORS

       Eduard Bloch
	   This manual page was written by Eduard Bloch in roff.

       Goneri Le Bouder
	   Converted manpages to SGML.

       Neil Williams
	   Converted manpages to DocBook XML and current Debian maintainer

COPYRIGHT

       Copyright (C) 2009 Eduard Bloch

Release: 0.8.2							     May 2009								 SVN-DO(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Select Distinct on multiple fields

Discussion started by: Refresher

2. Shell Programming and Scripting

Select distinct values from a flat file

Discussion started by: smalya

3. Programming

Select several minimum values from row (MySQL)

Discussion started by: Trump

4. Shell Programming and Scripting

To count distinct fields in a row

Discussion started by: Abhik