03-19-2009
sort -t "|" -k 6 -n -r sortsalary.txt
9876|bill johnson |director |production|03/12/50|130000
2365|john woodcock |director |personnel |05/11/47|120000
2233|charles harris |g.m. |sales |12/12/52|90000
5678|robert dylan |d.g.m. |marketing |04/19/43|85000
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a shell scripting. This will take 7 digit number in each line and add 7 digit number with next subsequent lines ( normal addition ).
Eg:
0000001
0000220
0001235
0000022
0000023
...........
.........
........
Like this i am having around 1500000 records. After adding... (23 Replies)
Discussion started by: thambi
23 Replies
2. Shell Programming and Scripting
Hi ....
iam having a file with 20,000 rows and 56 colums.
Iam trying to sort a file ....for that iam using 'sort' command.
If iam having 3 and 5 key colums etc ... as numerical this 'sort' command will work? what ihave to do ?
sample example :
E100|0|19940102|1|11111|E003... (3 Replies)
Discussion started by: satyam_sat
3 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I have a file which has data as
path/1.xml path/2.xml,...(each in separate lines)
I want to sort this file in order. It is not working when I give
"sort filename"
The number of "/" in path can vary.
Thanks,
Floyd (1 Reply)
Discussion started by: asmfloyd
1 Replies
4. Shell Programming and Scripting
I've been on holiday, and the brain's clearly not back in gear yet...
On Solaris, I have a simple list of package names...
DGBUpPost1.43_R1
DGSApp1.44_S1
DGSApp1.47_V1
DGSApp1.48_W0
DGPEuroC1.10_K0
DGPEuroC1.11_L0
DGPEuroC1.9_J0
DGSRet1.10_K0
I just want to properly sort them into... (2 Replies)
Discussion started by: JerryHone
2 Replies
5. Shell Programming and Scripting
Hi All,
My folder contains the files as:
$ ls -lrt
total 50
lms_prap_rf_20100422_99.xml
lms_prap_rf_20100422_9.xml
lms_prap_rf_20100422_100.xml
lms_prap_rf_20100422_10.xml
lms_prap_rf_20100426_1.xml
I need to get the sorting of the above file based on numbers. I need first file in... (5 Replies)
Discussion started by: sreejitnair123
5 Replies
6. UNIX for Advanced & Expert Users
hi everyone, I am kind of new to this forum. I need help in sorting this data out accordingly, I am actually doing a traceroute application and wants my AS path displayed in front of my address like this;
192.168.1.1 AS28513 AS65534 AS5089 AS5089 .... till the last AS number and if possible... (1 Reply)
Discussion started by: sam127
1 Replies
7. Shell Programming and Scripting
I have files with the name
myfile_YYMMDD.txt
I need to sort them by their date stamp. I know this will work.
ls -lrt * | awk '{print $9}' | cut -d "_" -f3 | sort
However, it just returns YYMMDD.txt
I can then append the myfile_ to it. However, that myfile_ may change. How do... (1 Reply)
Discussion started by: guessingo
1 Replies
8. Shell Programming and Scripting
Hello everyone, I'm in need of some assistance. I'm currently enrolled in an introductory UNIX shell programming course and, well halfway through the semester, we are receiving our first actual assignment. I've somewhat realized now that I've fallen behind, and I'm working to get caught up, but for... (1 Reply)
Discussion started by: MrMagoo22
1 Replies
9. Shell Programming and Scripting
Hi All,
I am using the below script which has awk command, but it is not returing the expected result. can some pls help me to correct the command.
The below script sample.ksh should give the result if the value of last 4 digits in the variable NM matches with the variable value DAT. The... (7 Replies)
Discussion started by: G.K.K
7 Replies
10. Shell Programming and Scripting
Hi All,
I am working on a huge pile of data. Its about a service initiating a call and and finishing it.
The columns that I have is:
Date Time URL Call Type ServiceName
5/11/2015 15:00:00 http-/0.0.0.0:8091-9 going to... (3 Replies)
Discussion started by: Junaid Subhani
3 Replies
LEARN ABOUT DEBIAN
class::dbi::columngrouper
Class::DBI::ColumnGrouper(3pm) User Contributed Perl Documentation Class::DBI::ColumnGrouper(3pm)
NAME
Class::DBI::ColumnGrouper - Columns and Column Groups
SYNOPSIS
my $colg = Class::DBI::ColumnGrouper->new;
$colg->add_group(People => qw/star director producer/);
my @cols = $colg->group_cols($group);
my @all = $colg->all_columns;
my @pri_col = $colg->primary;
my @essential_cols = $colg->essential;
DESCRIPTION
Each Class::DBI class maintains a list of its columns as class data. This provides an interface to that. You probably don't want to be
dealing with this directly.
METHODS
new
my $colg = Class::DBI::ColumnGrouper->new;
A new blank ColumnnGrouper object.
clone
my $colg2 = $colg->clone;
Clone an existing ColumnGrouper.
add_column / find_column
$colg->add_column($name);
my Class::DBI::Column $col = $colg->find_column($name);
Add or return a Column object for the given column name.
add_group
$colg->add_group(People => qw/star director producer/);
This adds a list of columns as a column group.
group_cols / groups_for
my @colg = $cols->group_cols($group);
my @groups = $cols->groups_for(@cols);
This returns a list of all columns which are in the given group, or the groups a given column is in.
columns_in
my @cols = $colg->columns_in(@groups);
This returns a list of all columns which are in the given groups.
all_columns
my @all = $colg->all_columns;
This returns a list of all the real columns.
primary
my $pri_col = $colg->primary;
This returns a list of the columns in the Primary group.
essential
my @essential_cols = $colg->essential;
This returns a list of the columns in the Essential group.
perl v5.12.4 2005-09-14 Class::DBI::ColumnGrouper(3pm)