Help with sort First Column followed by Second Column
Input file:
Desired Output:
Command try:
I wanna sort the number after DNX at first column from smallest to largest then followed by sort the number _iX after at second column from smallest to largest too.
Thanks for any advice.
Last edited by perl_beginner; 05-04-2016 at 12:19 AM..
Hi, Iam new to unix. I have one input file .
Input file :
ID1~Name1~Place1
ID2~Name2~Place2
ID3~Name3~Place3
I need output such that only first column should change to fixed width column of 15 characters of length.
Output File:
ID1<<12 spaces>>Name1~Place1
ID2<<12... (5 Replies)
Hi,
This is my input file:
ali 5 usa abc
abu 4 uk bca
alan 6 brazil bac
pinky 10 utah sdc
My desired output:
pinky 10 utah sdc
alan 6 brazil bac
ali 5 usa abc
abu 4 uk bca
Based on the column two, I want to do the descending order and print out other related column at the... (3 Replies)
Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2
file 1 sample
SNDK 80004C101 AT
XLNX 983919101 BB
NETL 64118B100 BS
AMD 007903107 CC
KLAC 482480100 DC
TER 880770102 KATS
ATHR 04743P108 KATS... (7 Replies)
Hello,
I am running on AIX.I have a question about sorting in UNIX.
if my file is something like this:
a c
b d
a b
b c
a a
I want to sort on column 1 only. The following statement does not seem to work, it still considers the rest of the line in the sorting results: sort... (2 Replies)
Hi Expert,
Please kindly need your help, I dont have any idea how to make this input to be as output.
Thanks before
$ more input.dat
@zmap_fault HEADER , FALT, 80, 1
X (EASTING) , 1, 1, 1, 1, 15, 7, 0.1000000E+31, , 15, 7, 0
Y... (5 Replies)
This is my input file :
# cat list 20130430121600, cucm, location,76,2 20130430121600,cucm1,location1,76,4 20130430122000,cucm,location,80,8 20130430122000,cucm1,location1,90,8 20130430140000,cucm1,location1,87,11 20130430140000, cucm,location,67,9
This is the required output
... (1 Reply)
How to sort based on the 4 the column . The input data has a header and output needs to be sorted based on the 4th column rbcid.
I tried below code but not getting results
sort -u -t'|' -k4,4r file1 > file2
time|tourit|nofdays|rbcid|blank|type|value|nill|valuedesc|name... (6 Replies)
How to sort the following output based on lowest to highest BE?
The following sort does not work.
$ sort -t. -k1,1n -k2,2n bfd.txt
BE31.116 0s 0s DOWN DAMP
BE31.116 0s 0s DOWN DAMP
BE31.117 0s 0s ... (7 Replies)
Discussion started by: sand1234
7 Replies
LEARN ABOUT DEBIAN
alzabo::create::index
Alzabo::Create::Index(3pm) User Contributed Perl Documentation Alzabo::Create::Index(3pm)NAME
Alzabo::Create::Index - Index objects for schema creation
SYNOPSIS
use Alzabo::Create::Index;
DESCRIPTION
This object represents an index on a table. Indexes consist of columns and optional prefixes for each column. The prefix specifies how
many characters of the columns should be indexes (the first X chars). Some RDBMS's do not have a concept of index prefixes. Not all col-
umn types are likely to allow prefixes though this depends on the RDBMS. The order of the columns is significant.
INHERITS FROM
"Alzabo::Index"
Note: all relevant documentation from the superclass has been merged into this document.
METHODS
new
The constructor takes the following parameters:
* table => "Alzabo::Create::Table" object
The table that this index is indexing.
* columns => [ "Alzabo::Create::Column" object, .. ]
* columns => [ { column => "Alzabo::Create::Column" object, prefix => $prefix }, repeat as needed ... ]
This parameter indicates which columns that are being indexed. It can either be an array reference of column objects, or an array ref-
erence of hash references, each with a key called column and one called prefix.
The prefix key is optional.
* unique => $boolean
Indicates whether or not this is a unique index.
* fulltext => $boolean
Indicates whether or not this is a fulltext index.
* function => $string
This can be used to create a function index where supported. The value of this parameter should be the full function, with column
names, such as "LCASE( username )".
The "columns" parameter should include all the columns used in the function.
Returns a new "Alzabo::Create::Index" object.
Throws: "Alzabo::Exception::Params", "Alzabo::Exception::RDBMSRules"
table
Returns the "Alzabo::Create::Table" object to which the index belongs.
columns
Returns an ordered list of the "Alzabo::Create::Column" objects that are being indexed.
add_column
Adds a column to the index.
This method takes the following parameters:
* column => "Alzabo::Create::Column" object
* prefix => $prefix (optional)
Throws: "Alzabo::Exception::Params", "Alzabo::Exception::RDBMSRules"
delete_column ("Alzabo::Create::Column" object)
Deletes the given column from the index.
Throws: "Alzabo::Exception::Params", "Alzabo::Exception::RDBMSRules"
prefix ("Alzabo::Create::Column" object)
A column prefix is, to the best of my knowledge, a MySQL specific concept, and as such cannot be set when using an RDBMSRules module for a
different RDBMS. However, it is important enough for MySQL to have the functionality be present. It allows you to specify that the index
should only look at a certain portion of a field (the first N characters). This prefix is required to index any sort of BLOB column in
MySQL.
This method returns the prefix for the column in the index. If there is no prefix for this column in the index, then it returns undef.
set_prefix
This method takes the following parameters:
* column => "Alzabo::Create::Column" object
* prefix => $prefix
Throws: "Alzabo::Exception::Params", "Alzabo::Exception::RDBMSRules"
unique
Returns a boolean value indicating whether the index is a unique index.
set_unique ($boolean)
Sets whether or not the index is a unique index.
fulltext
Returns a boolean value indicating whether the index is a fulltext index.
set_fulltext ($boolean)
Set whether or not the index is a fulltext index.
Throws: "Alzabo::Exception::Params", "Alzabo::Exception::RDBMSRules"
register_column_name_change
This method takes the following parameters:
* column => "Alzabo::Create::Column" object
The column (with the new name already set).
* old_name => $old_name
This method is called by the table object which owns the index when a column name changes. You should never need to call this yourself.
Throws: "Alzabo::Exception::Params"
id
The id is generated from the table, column and prefix information for the index. This is useful as a canonical name for a hash key, for
example.
Returns a string that is the id which uniquely identifies the index in this schema.
AUTHOR
Dave Rolsky, <autarch@urth.org>
perl v5.8.8 2007-12-23 Alzabo::Create::Index(3pm)