Vertical sorting of columns Post: 302341837

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sorting based on columns

Hi, I want a list of entries in 3 space delimited columns. I want to sort entries based on the very first column. Rows can't be changed. For example: If I have... Abc Abc Acc Bca Bda Bdd Cab Cab Cbc Dbc Dca Dda Abc Abc Acc the output should be... Abc Abc Acc Abc Abc Acc Bca...

2. UNIX for Advanced & Expert Users

sorting of varchar columns

Hi , I need to sort a file based on multiple columns All the columns are of varchar type can any one give me the command to sort for varchar columns? Thanks

3. Shell Programming and Scripting

Sorting multiple columns

Hi, We have a requirement of need to sort a file based on fields 1,3 and 4. I tried with sort command however it is not giving expected output, can we achieve any other way? Please let me know ASAP. File a e w a a b a a a a d g a a h h c d a e a a a w Output a b a a a a a w a a d...

4. UNIX for Dummies Questions & Answers

Sorting by multiple columns

I have a space delimited text file that I would like to sort by multiple columns. First I want to sort by column 1, then by column 2. Both columns are numerical. Thanks!

5. Shell Programming and Scripting

sorting and adding columns

i have a file with two columns, and i want to uniquely sort the values in fist column and add the corresponding values in the second columns eg file a contents tom 200 john 300 sow 500 tom 800 james 50 sow 300 output shpould be in file b as tom 1000 john 300 sow 800 james 50

6. UNIX for Dummies Questions & Answers

Sorting by Multiple Columns

Hi I have a text file that has four columns (Logonid,First Name,Last Name,Status) Logonid First Name Last Name Status abc2 Fred Mercury Inactive abc1 John Deacon Active abc3 Roger Taylor Active abc4 Brian ...

7. Shell Programming and Scripting

Help in sorting multiple columns

Hello all, I am using printf to print the sorted o/p in my script.I am trying to sort in following way but doesn't work. printf "%13s %2s UDP %15s:%s Program %4s HD: %23s HD: %23s %10s %s %s %3s days %3s hours\n" $encoder $i "${ipaddr}" ${portno} ${progno} ${inres} ${outres} ${inrate}...

8. Shell Programming and Scripting

CSV Sorting on only particular columns

Hello! So ive been presented with this comma-delimited file: I need a print to look as below " lastname, phone_number, zip for every person with a last name starting with the letter H, I only with a 650-area code phone number. output should be sorted by reverse ZIP code " I only have...

9. UNIX for Dummies Questions & Answers

Sorting rows to columns

Dear all, I need your help to sort out a file with more then 15, 000 rows, input file has following format : AT4560 GO:1289GO:8915GO:9243GO:5739GO:6757GO:9245GO:9507output should be like: AT4560 GO:1289 AT4560 GO:8915 AT4560 GO:9243 AT4560 GO:5739 AT4560 GO:6757 AT4560 GO:9245...

10. Shell Programming and Scripting

Sorting by columns

Hi, I have a tab delimited columnar file where I want to remove lines wherever two particular columns match. so for this file, I want to toss the lines where columns 1 and 2 match: a a 1 3 a b 2 4 b b 3 5 because there are matches column 1 and 2 in lines 1 and 3, I would like a script to...

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)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sorting based on columns

Discussion started by: MobileUser

2. UNIX for Advanced & Expert Users

sorting of varchar columns

Discussion started by: laxmi131

3. Shell Programming and Scripting

Sorting multiple columns

Discussion started by: Nagapandi

4. UNIX for Dummies Questions & Answers

Sorting by multiple columns

Discussion started by: evelibertine