Sponsored Content
Full Discussion: awk sorting
Top Forums Shell Programming and Scripting awk sorting Post 302074182 by Jaken on Sunday 21st of May 2006 06:28:26 AM
Old 05-21-2006
Sorry, I miss typed, was quite late at nigh -_-. I meant to ask how would I go about sorting the second column of data (which are numbers) in ascending order.

I currently haven't sorted any data. I can sort the first set of data quite simply by adding a " | sort" at the end of the pipe, but by default this sorts the first column, but i want to sort the second.

Sorry about that :P
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sorting in awk

i have following file have following type of data 1~%%~fcashfafh~%%~9797 can i sort(numeric) the file on first field and then on last feild using awk (3 Replies)
Discussion started by: mahabunta
3 Replies

2. Shell Programming and Scripting

Is there any better way for sorting in bash/awk

Hi, I have a file which is:- 1 6 4 8 2 3 2 1 9 3 2 1 3 3 5 6 3 1 4 9 7 8 2 3 I would like to sort from field $2 to field $6 for each of the line to:- 1 2 3 4 6 8 2 1 1 2 3 9 3 1 3 3 5 6 4 2 3 7 8 9 I came across this Arrays on example 26-6. But it is much complicated. I am... (7 Replies)
Discussion started by: ahjiefreak
7 Replies

3. Shell Programming and Scripting

AWK, sorting-if and print help.

Little-bit of awk experience, need some of the expert help on here. Browsed around here, got a little further, but I am still missing some pieces. Can you help me fill-in my missing awk cells? Sample data file (leaving out ","'s): Column 1 Column 2 Column 3 Column 4 ... (10 Replies)
Discussion started by: boolean2222
10 Replies

4. Shell Programming and Scripting

Sorting with sed,awk ...

I need to sort this input using sed, awk or any other tool to give below output Input: RXOCF-8 CLASS 2A 57 RU 40 RXORX-8-0 CLASS 1B 23 45 16 RXORX-8-1 EXTERNAL CLASS 2A (12 Replies)
Discussion started by: aydj
12 Replies

5. Shell Programming and Scripting

Sorting inside awk

I have an array with five columns and i want to write it to a file. Before writing it i must sort it using the field in the fifth column. _________________________________________ |field 1|field 2|field 3|field 4|field 5| | | | | | | | | | |... (6 Replies)
Discussion started by: beatblaster666
6 Replies

6. Shell Programming and Scripting

AWK/GREP sorting help

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

7. Shell Programming and Scripting

Sorting a .csv using awk or other

Hello all, I am new here and *relatively* new to Unix. I have a bit of an emergency. I have a three column file that I need to sort: sample name, miRNA, reads per million (RPM) There are multiple samples, and for each sample name there are multiple miRNAs and associated RPMs. Some of these... (6 Replies)
Discussion started by: dunnybocter
6 Replies

8. Shell Programming and Scripting

Sorting within a record using AWK

Hello, I have a file which has the following format: I have to do is sort individual records in the file based on the 4th field. Each record starts with "Module". Is there an easy way to do this using awk. I have tried piping output from awk to sort and also using "sort" inside awk but... (8 Replies)
Discussion started by: fifteate
8 Replies

9. Shell Programming and Scripting

Sorting output of AWK array

I need help to sort the output of an awk array Example datadata="1 blue 2 green 3 blue 4 yellow 5 blue 6 red 7 yellow 8 red 9 yellow 10 yellow 11 green 12 orange 13 black" My awk line to get output in one lineecho "$data" | awk ' {arr++; next} END { for (i in arr) { if(arr>1 )... (2 Replies)
Discussion started by: Jotne
2 Replies

10. Shell Programming and Scripting

Help with awk sorting with different values

Hello, I have a file as follows: BTA Pos KLD 4 79.7011 5.7711028907 4 79.6231 5.7083918219 5 20.9112 4.5559494707 5 58.0002 3.4423546273 6 38.2569 4.7108176788 6 18.3889 7.3631759258 (1 Reply)
Discussion started by: Homa
1 Replies
evmsort(1)						      General Commands Manual							evmsort(1)

NAME
evmsort - Sorts events SYNOPSIS
evmsort [-A] [-s sort_spec] [-t show_template] [filename | -] OPTIONS
Automatically starts evmshow to produce a formatted display of the sorted events. The specification to be used in sorting events. See the DESCRIPTION section for the syntax of the sort_spec, and for details of the default sort order. Template string to be passed to evmshow if the -A option is also specified. If the -A option is not specified, this argument is ignored. See the evmshow(1) reference page for a description of the template string. OPERANDS
Reads event sources from filename. If filename is omitted, or is specified as -, event sources are read from stdin. DESCRIPTION
The evmsort command reads and sorts a stream of EVM events. By default, events are read from stdin, and are sorted into ascending time- stamp order. Sorted events are written to the command's stdout stream in the form of raw EVM events. The sort order can be specified by supplying a sort_spec, either through the -s option or by setting the environment variable EVM_SORT_SPEC to the required specification. The specification is a character string of the form: @key_item[+|-] [ :@key_item[+|-] ] The key_item is the name of any EVM standard data item and the @ character is optional. If the special key_item @@ is specified, the event's format data item is expanded as described in the evmshow(1) reference page, and the resulting string is used as the sort key. The optional trailing + or - character indicates ascending (+) or descending (-) sort. By default, items are sorted in ascending order. Multiple items can be specified in the string by separating them with colon characters (:). The left-most key_item in the specification is the most significant key. If a key_item that is included in the sort specification is not present in an event read from the input stream, the item is considered to have a low value for that event. For example: if input events are being sorted in ascending order according to their name data items, and one event does not contain a name, that event will appear first in the output stream. If the -A option is specified, evmsort automatically starts evmshow and pipes the sorted event stream into it, producing a sorted and for- matted display of events. If a show_template argument is supplied, the specified template string is passed to evmshow through its own -t option. See the evmshow(1) reference page for more information. RESTRICTIONS
The evmsort command rejects attempts to output raw events to a terminal device. ENVIRONMENT VARIABLES
The following environment variables affect the execution of evmsort: This variable contains a string formatted as described for a sort_spec. If the -s flag is omitted, the string is used as the sort_spec. EXAMPLES
The following example retrieves all events with a priority of 300 or greater, sorts them into descending order of priority (most urgent first) and then ascending order of time (oldest first), and automatically runs evmshow to display them. evmget -f '[priority >= 300]' | evmsort -s "@priority-:@timestamp" | evmshow -t "@priority @timestamp @@" The following example yields a list of all events, sorted latest first within name. evmget | evmsort -s "@name:@timestamp-" | evmshow -t "@name @timestamp @@" The following example yields a list of all events, sorted first in order of their formatted messages and then in ascending order of time. Events are passed to evmshow for display, and subsequently to the more command for viewing. evmget | evmsort -A -s "@@:@timestamp" -t "@timestamp @@" | more EXIT VALUES
The following exit values are returned: Successful completion An error occurred SEE ALSO
Commands: evmget(1), evmpost(1), evmshow(1), evmwatch(1) Files: evmchannel.conf(4) Event Management: EVM(5) EVM Events: EvmEvent(5) Event Filter: EvmFilter(5) delim off evmsort(1)
All times are GMT -4. The time now is 07:25 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy