sorting(both Ascending & Descending) files based on multiple fields
Hi All,
I am encountered with a problem while sorting a file based on multiple columns . I need to sort like:
(field2,ascending) , (field3,ascending) ,(field8,descending) , (field7,ascending),(field13,ascending).
So far i was sorting only in ascending order but here i need to use one descending field also.
Please see the sample text which needs to be sorted based on above rule.The text is TAB delimited.
Previously i was using sort like
sort -t "`echo -e "\t"`" +1 -2 +2 -3 >tmp This sort file using 2nd and 3rd field in ascending order only having TAB as delimiter.
Please help me to sort it out.
Thanks
Neeraj
Last edited by radoulov; 05-18-2009 at 08:56 AM..
Reason: added code tags
Hi,
I have an urgent task here. I am required to sort a flat file based on multiple columns which are based on the character position in that line. I am restricted to use the character position instead of the space and sort +1 +2 etc to do the sorting.
I understand that there is a previous... (8 Replies)
Dear All,
I have below attached file in which i have many nos, i want the last ascending order nos. The brief description is given below.
File
315
381
432
315
381
432
315
381
432
315
381
432
315
381
432 (6 Replies)
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)
I have a bash script which takes a log file with each record separated by a #. The records have multiple fields but field $1 is always the date and time. When the script is run it prints the record just fine from oldest to newest. I need to have records print out from newest first.
Here is the... (7 Replies)
Hello,
I have data where words are separated by a delimiter. In this case "="
The number of delimiters in a line can vary from 4to 8. The norm is 4.
Is it possible to have a script where the file could be separated starting with highest number of delimiters and ending with the lowest
An... (8 Replies)
I want to sort values of a hash in ascending order.
my %records;
for my $value (sort values %records){print $value,"\n";}
When I use the above code I get values in this order: 1,10,11,2,3,4,5,6,7,8,9. But, I need values in my output in this order: 1,2,3,4,5,6,7,8,9,10,11.
Can Someone... (1 Reply)
Hi,
I have this single file with a number of sequence inside it of format
>string1
data
>string100
data
>string10
.....
>string5
...
>string67
......
the dots represent data.
I wanted to get the sequences arranged in ascending order like
>string1
data
>string5 (5 Replies)
Hi,
I am trying to sort the following file in descending order of its fourth column.
2 1 363828 -2.423225e-03
3 1 363828 4.132763e-03
3 2 363828 8.150133e-03
4 1 363828 4.126890e-03
I use
sort -k4,4g -r input.txt > output.txt ... (1 Reply)
Discussion started by: evelibertine
1 Replies
LEARN ABOUT DEBIAN
search::xapian::enquire
Xapian::Enquire(3pm) User Contributed Perl Documentation Xapian::Enquire(3pm)NAME
Search::Xapian::Enquire - Make queries against a database
DESCRIPTION
This class provides an interface to the information retrieval system for the purpose of searching.
METHODS
new
set_query
takes either a ready made Search::Xapian::Query or a scalar containing a query, which in that case will be passed to
Search::Xapian::Query's constructor, together with any other passed arguments.
set_query_object <query>
get_query
matches <start> <size> [<check_at_least>]
Takes the start element, and maximum number of elements (and optionally the minimum number of matches to check), and returns an array
tied to Search::Xapian::MSet::Tied.
get_matching_terms_begin
Returns a Search::Xapian::TermIterator, pointing to the start of the stream.
get_matching_terms_end
Returns a Search::Xapian::TermIterator, pointing to the end of the stream.
set_collapse_key <collapse_key>
set_docid_order <order>
Set the direction in which documents are ordered by document id in the returned MSet.
This order only has an effect on documents which would otherwise have equal rank. For a weighted probabilistic match with no sort
value, this means documents with equal weight. For a boolean match, with no sort value, this means all documents. And if a sort value
is used, this means documents with equal sort value (and also equal weight if ordering on relevance after the sort).
order can be ENQ_ASCENDING (the default, docids sort in ascending order), ENQ_DESCENDING (docds sort in descending order), or
ENQ_DONT_CARE (docids sort in whatever order is most efficient for the backend.)
Note: If you add documents in strict date order, then a boolean search - i.e. set_weighting_scheme(Search::Xapian::BoolWeight->new()) -
with set_docid_order(ENQ_DESCENDING) is a very efficient way to perform "sort by date, newest first".
set_cutoff <percent_cutoff> [<weight_cutoff>]
set_sort_by_relevance
Set the sorting to be by relevance only. This is the default.
set_sort_by_value <sort_key> [<ascending>]
Set the sorting to be by value only.
sort_key - value number to reorder on. Sorting is with a string compare. If ascending is true (the default) higher is better; if
ascending is false, lower is better.
ascending - If true, document values which sort higher by string compare are better. If false, the sort order is reversed. (default
true)
set_sort_by_value_then_relevance <sort_key> [<ascending>]
Set the sorting to be by value, then by relevance for documents with the same value.
sort_key - value number to reorder on. Sorting is with a string compare. If ascending is true (the default) higher is better; if
ascending is false, lower is better.
ascending - If true, document values which sort higher by string compare are better. If false, the sort order is reversed. (default
true)
set_sort_by_relevance_then_value <sort_key> [<ascending>]
Set the sorting to be by relevance then value.
Note that with the default BM25 weighting scheme parameters, non-identical documents will rarely have the same weight, so this setting
will give very similar results to set_sort_by_relevance(). It becomes more useful with particular BM25 parameter settings (e.g.
BM25Weight(1,0,1,0,0)) or custom weighting schemes.
sort_key - value number to reorder on. Sorting is with a string compare. If ascending is true (the default) higher is better; if
ascending is false, lower is better.
ascending - If true, document values which sort higher by string compare are better. If false, the sort order is reversed. (default
true)
set_sort_by_key <sorter> [<ascending>]
Set the sorting to be by key only.
sorter - the functor to use to build the key.
ascending - If true, keys which sort higher by string compare are better. If false, the sort order is reversed. (default true)
set_sort_by_key_then_relevance <sorter> [<ascending>]
Set the sorting to be by key, then by relevance for documents with the same key.
sorter - the functor to use to build the key.
ascending - If true, keys which sort higher by string compare are better. If false, the sort order is reversed. (default true)
set_sort_by_relevance_then_key <sorter> [<ascending>]
Set the sorting to be by relevance then key.
sorter - the functor to use to build the key.
ascending - If true, keys which sort higher by string compare are better. If false, the sort order is reversed. (default true)
get_mset
Get match set.
get_eset <maxitems> <rset> [<decider>]
Get set of query expansion terms.
get_description
Return a description of this object.
SEE ALSO
Search::Xapian::Query, Search::Xapian::Database
perl v5.14.2 2012-05-09 Xapian::Enquire(3pm)