Perl sort unique by one field only Post: 302299532

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sort and Unique in Perl

Hi, May I know, if a pipe separated File is large, what is the best method to calculate the unique row count of 3rd column and get a list of unique value of the 3rdcolum? Thanks in advance!

2. Shell Programming and Scripting

Sort alpha on 1st field, numerical on 2nd field (sci notation)

I want to sort alphabetically on the first field and sort in descending numerical order on the 2nd field. With a normal "sort -r -n" it does this: abc ||| 5e-05 ||| bla abc ||| 3 ||| ble def ||| 1 ||| abc def ||| 0.2 ||| def As you can see it ignores the fact that 5e-05 is actually 0.00005...

3. Shell Programming and Scripting

perl sort array by field

Hi Everyone, Any simple code can simplify the code below, please advice. Thanks # cat 2.pl #!/usr/bin/perl use warnings; use strict; my @aaaaa = <DATA>; my @uids; foreach (@aaaaa) { my @ccccc = split (",", $_); push @uids, $ccccc;...

4. Shell Programming and Scripting

Perl script to sort data on second numeric field

Hi, I'm a learner of PERL programming. I've a input file with the below data: SWAT_5, 1703, 2010-09-21 SWAT_6, 2345, 2010-09-21 SWAT_7, 1792, 2010-09-21 SWAT_8, 1662, 2010-09-21 SWAT_9, 1888, 2010-09-21 VXHARP_1, 171, 2010-09-21 I need to sort this data based on the second...

5. Shell Programming and Scripting

Awk sort and unique

6. Shell Programming and Scripting

Unique sort with two fields

I have a file with contents below 123,502 123,506 123,702 234,101 235,104 456,104 456,100 i want to sort such that i get a unique value in column A, and for those with multiple value in A, i want the lowest value in B. output should be 123,502 234,101 235,104 456,100

7. Shell Programming and Scripting

Unique sort with three fields

I have another file with three columns A,B,C as below 123,1,502 123,2,506 123,3,702 234,4,101 235,5,104 456,6,104 456,7,100 i want to sort such that i get a unique value in column A, and for those with multiple value in A, i want the lowest value in C. output should be Code:...

8. Shell Programming and Scripting

Unique Field

I have this input file tilenet_test:clar_r5_performance:server_2:4.80762:0%:APM00083103999-009E,APM00083103999-009F tilenet_int:clar_r5_performance:server_2:4.80762:0%:APM00083103999-00C4...

9. UNIX for Dummies Questions & Answers

Print unique lines without sort or unique

I would like to print unique lines without sort or unique. Unfortunately the server I am working on does not have sort or unique. I have not been able to contact the administrator of the server to ask him to add it for several weeks.

10. Shell Programming and Scripting

Sort unique

Hi, I have an input file that I have sorted in a previous stage by $1 and $4. I now need something that will take the first record from each group of data based on the key being $1 Input file 1000AAA|"ZZZ"|"Date"|"1"|"Y"|"ABC"|""|AA 1000AAA|"ZZZ"|"Date"|"2"|"Y"|"ABC"|""|AA...

LEARN ABOUT DEBIAN

cssort

CSSORT(1p)						User Contributed Perl Documentation						CSSORT(1p)

NAME

       cssort -- Czech sort

FORMAT

       cssort [ "-c"list | "-f"list ["-d"regexp]] [files ...]

SYNOPSIS

	       cssort -c10-15,50-,25-45 < file
	       cssort -f3,5-6 < file
	       cssort -f3,5-6 -s: < file

DESCRIPTION

       Cssort is a utility that sorts input lines according to rules used in the Czech language. You can run it without any options, then it just
       uses whole lines for sorting. With the options, it's possible to specify parts of the lines to be used for comparison.

       list
	   A comma-separated list of integer field numbers or field ranges. The are indexed from 1 and if a range is open (eg. "5-"), it means all
	   remaining fields from the starting number.

       -c  Stands for columns and the list that follows specifies byte ranges on the line. You will probably use this option to sort data with
	   fixed width fields.

       -f  Fields that will be used for sort.

       -d  Delimiter that separates fields in the -f option. It is a Perl regular expression, the default is "[ 	]+", which means any number of
	   spaces or tabs in a row.

       The program assumes ISO-8859-2 encoding. Some way to specify another input encoding will come in the next versions. If you need to sort
       files with different encodings, you might want to check the cstocs conversion utility.

SEE ALSO

       Cz::Sort(3), cstocs(1).

AUTHOR

       Jan Pazdziora, adelton@fi.muni.cz.

perl v5.10.1							    2010-01-16								CSSORT(1p)