Sponsored Content
Full Discussion: Sorting based on columns
Top Forums Shell Programming and Scripting Sorting based on columns Post 302113894 by ennstate on Wednesday 11th of April 2007 12:43:11 AM
Old 04-11-2007
The following are the different inputs and output which i got using the sort command,
Input:1
HTML Code:
cat /tmp/s1
    Abc Acc
Bca Bda Bdd
       Cbc
Dbc Dca Dda
Abc Abc Acc
HTML Code:
sort -k1d /tmp/s1
OUTPUT
HTML Code:
Abc Abc Acc
    Abc Acc
Bca Bda Bdd
       Cbc
Dbc Dca Dda
HTML Code:
sort -k1d /tmp/s1  |  sed -e 's/^ *//g'
OUTPUT
HTML Code:
Abc Abc Acc
Abc Acc
Bca Bda Bdd
Cbc
Dbc Dca Dda
Input 2
Note:Blank space is different
HTML Code:
 cat /tmp/s2
  Abc Acc
Bca Bda Bdd
   Cbc
Dbc Dca Dda
Abc Abc Acc
HTML Code:
sort -k1d /tmp/s2  |  sed -e 's/^ *//g'
OUTPUT
HTML Code:
Abc Abc Acc
Abc Acc
Bca Bda Bdd
Cbc
Dbc Dca Dda
Hope this helps.

Thanks
Nagarajan Ganesan.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

sorting data based on multi columns

Hi all I have data in following format: CSCH74,2007,1,09103,15 CSCH74,2007,10,09103,0 CSCH74,2007,11,09103,0 CSCH74,2007,12,09103,0 CSCH74,2007,2,09103,15 CSCH74,2007,3,09103,194 CSCH74,2007,4,09103,115 CSCH74,2007,5,09103,66 CSCH74,2007,6,09103,0 CSCH74,2007,7,09103,0... (2 Replies)
Discussion started by: sumeet
2 Replies

2. Shell Programming and Scripting

sorting file based on two or more columns

Hi gang. I'm using a unix/mac system and i'm trying to sort a file (more than 1,000,000 lines). chr1 100000965 100001001 - chr1 100002155 100002191 + chr1 100002165 100002201 + chr1 100002525 100002561 - chr1 10000364 ... (2 Replies)
Discussion started by: labrazil
2 Replies

3. 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 Replies)
Discussion started by: laxmi131
3 Replies

4. Shell Programming and Scripting

Sorting based on Multiple columns

Hi, I have a requirement whereby I have to sort a flat file based on Multiple Columns (similar to ORDER BY Clause of Oracle). I am getting 10 columns in the flat file and I want the file to be sorted on 1st, 3rd, 4th, 7th and 9th columns in ascending order. The flat file is pipe seperated. Any... (15 Replies)
Discussion started by: dharmesht
15 Replies

5. UNIX for Dummies Questions & Answers

Vertical sorting of columns

Please help to sort columns in this file: a b d f c e 1 4 10 16 7 13 2 5 11 17 8 14 3 6 12 18 9 15 I need to sort COLUMNS (so sort command doesn't work) like this: a b c d e f 1 4 7 10 13 16 2 5 8 11 14 17 3 6 9 12 15 18 I know sed can do it but don't know how... :( (7 Replies)
Discussion started by: coppuca
7 Replies

6. 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 Replies)
Discussion started by: Nagapandi
4 Replies

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}... (4 Replies)
Discussion started by: ramman
4 Replies

8. 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... (5 Replies)
Discussion started by: AAWT
5 Replies

9. 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... (2 Replies)
Discussion started by: mikey11415
2 Replies

10. Shell Programming and Scripting

Add new columns based on existing columns

Hi all, I am kind of stuck with printing my desired output. Please help me if you know how it can work. My input file(tab separated): NW_0068.1 41,16 100,900 NW_0699.1 4,2,19 200,700,80 My Output file (desired): NW_0068.1 41,16 100,900 100 - 141 NW_0068.1 41,16 100,900 ... (3 Replies)
Discussion started by: sam_2921
3 Replies
HTML::Template::Compiled::Classic(3pm)			User Contributed Perl Documentation		    HTML::Template::Compiled::Classic(3pm)

NAME
HTML::Template::Compiled::Classic - Provide the classic functionality like HTML::Template SYNOPSIS
use HTML::Template::Compiled::Classic compatible => 1; my $htcc = HTML::Template::Compiled::Classic->new( # usual parameters for HTML::Template::Compiled ); DESCRIPTION
This class provides features which can not be used together with features from HTML::Template::Compiled. These are: dots in TMPL_VARs If you want to use <TMPL_VAR NAME="some.var.with.dots"> you cannot use the dot-feature <TMPL_VAR NAME="some.hash.keys"> at the same time. Subref variables In HTML::Template, the following works: my $ht = HTML::Template->new( scalarref => "<TMPL_VAR foo>", ); $ht->param(foo => sub { return "bar" }); print $ht->output; # prints 'bar' This doesn't work in HTML::Template::Compiled (in the past it did, but as of HTC version 0.70 it won't any more, sorry). METHODS
compiler_class returns HTML::Template::Compiled::Compiler::Classic validate_var gets the var name (parsed out of "NAME="foo.bar"" and returns if the string is a valid var name perl v5.14.2 2012-05-26 HTML::Template::Compiled::Classic(3pm)
All times are GMT -4. The time now is 07:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy