Sponsored Content
Top Forums Shell Programming and Scripting Sorting a column in this scenario Post 302147492 by krishnan_6015@y on Tuesday 27th of November 2007 07:56:21 AM
Old 11-27-2007
Sorting a column in this scenario

Hi,

I need to sort the 3rd column in ascending order , each and every column are seperated by ~.

sample input file :

2~Lead Time Metrics~jennife1
2~Lead Time Metrics~mmullis
2~Lead Time Metrics~lisah
2~Lead Time Metrics~pros
2~Lead Time Metrics~kenward

can any one help me out .

i gave sort +3 -r input.lst >> output.lst

Thanks,
Mohana Krishnan
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Sorting in unix using column number

Hi All, Can anyone tell me how to sort data in a file using the “sort” command? Note that the records in the data file are not separated into fields. I know only the column positions of the data on which sorting should be done. For example say I've to sort based on the data present in between... (1 Reply)
Discussion started by: swat
1 Replies

2. Shell Programming and Scripting

Sorting By Column

I have almost got my unix program working that im working on as a personal project, my file tvs.txt has around 500 records so this would make it alot easier for me to find specific information. I have a file called tvs.txt, I'm using pico to edit the files and i want to be able to sort on the a... (6 Replies)
Discussion started by: john123
6 Replies

3. Shell Programming and Scripting

Sorting a particular column in PERL

I have a file abc.txt which contains data in th following format abc,23 hgfh,87 tweg,89 jdfjn,74 I want to sort on the basis of column (the second one). It should be numerical sort. output should be abc,23 jdfjn,74 hgfh,87 tweg,89 I know how to do it in unix. I need a PERL code (1 Reply)
Discussion started by: centurion_13
1 Replies

4. Shell Programming and Scripting

sorting on one column

Hello all, Is there a way to sort only one column while keeping everything else intact. Take for example this situation: (all columns are space separated) 11 AA asdf 1 -0.5 xx 11 AA axdf 1 -0.6 xx 11 AA csls 1 -0.7 xx 11 AA hjkj 1 -0.4 xx 11 AA uius 1 -0.8 xx 22 AA asdf 1 -0.4 xx 22 AA... (7 Replies)
Discussion started by: jaysean
7 Replies

5. Shell Programming and Scripting

[Solved] Sorting a column in a file based on a column in a second file

Hello, I have two files as the following: File1: F0100020 A G F0100030 A T F0100040 A G File2: F0100040 A G BTA-28763-no-rs 77.2692 F0100030 A T BTA-29334-no-rs 11.4989 F0100020 A G BTA-29515-no-rs 127.006 I want to sort the second file based on the... (6 Replies)
Discussion started by: Homa
6 Replies

6. Shell Programming and Scripting

[Solved] Sorting a column based on another column

hello, I have a file as follows: F0100010 A C F0100040 A G BTA-28763-no-rs 77.2692 F0100020 A G F0100030 A T BTA-29334-no-rs 11.4989 F0100030 A T F0100020 A G BTA-29515-no-rs 127.006 F0100040 A G F0100010 A C BTA-29644-no-rs 7.29827 F0100050 A... (9 Replies)
Discussion started by: Homa
9 Replies

7. UNIX for Dummies Questions & Answers

Sorting one column underneath another

I am trying to arrange these columns so that they look like this: Xray2_1255555 Number of Copies: 1 Boxcar_1387305895 Number of Copies: 2 Fox_1387305896 Number of Copies: 2 But I have one column after another like this: Xray2_1255555 Number of Copies: 1 Xray2_12444444 Number of... (5 Replies)
Discussion started by: newbie2010
5 Replies

8. UNIX for Dummies Questions & Answers

Independent column sorting

Dear All, I have a set of columns (usually unknown number) and I would like to sort each of them (descending values) but my columns are independent. Can you please help me file1 1,5,7 3,4,9 2,6,8 outcome should be 1,4,7 2,5,8 3,6,9 I have tried sort -n -k1,1 -k2,2 -k3,3 but this... (8 Replies)
Discussion started by: A-V
8 Replies

9. Shell Programming and Scripting

Sorting unique by column

I am trying to sort, do uniq by 1st column and report this 4 columns tab delimiter table , eg chr10:112174128 rs2255141 2E-10 Cholesterol, total chr10:112174128 rs2255141 7E-16 LDL chr10:17218291 rs10904908 3E-11 HDL Cholesterol chr10:17218291 rs970548 8E-9 TG... (4 Replies)
Discussion started by: fat
4 Replies

10. Shell Programming and Scripting

Sorting a specific column!

What im trying to do is sort the output by the number on the second column and than limit the result to only the first three lines. This is the code idlist="x23s52; f34233; 2343xs; 25x34; si342d" cntr=1 idcnt=$(print $nidlist |tr ';' '\n' |wc -l) numofgrps=0 while (($cntr <= $idcnt))... (3 Replies)
Discussion started by: ajetangay
3 Replies
MMV(5)								File Formats Manual							    MMV(5)

NAME
mmv - Memory Mapped Values for Performance Co-Pilot SYNOPSIS
$PCP_TMP_DIR/mmv/<file> DESCRIPTION
The files in $PCP_TMP_DIR/mmv are generated by mmv_stats_init() function from libpcp_mmv library. There could be multiple files in this directory, each file representing a single source of the performance metrics. The metrics are harvested by the mmv PMDA which exports them to the rest of the Performance Co-Pilot infrastructure. FILE FORMAT
Each file starts with the following header: +-------+--------+--------------------------+ |Offset | Length | Name | +-------+--------+--------------------------+ | 0 | 4 | tag == "MMV" | +-------+--------+--------------------------+ | 4 | 4 | Version | +-------+--------+--------------------------+ | 8 | 8 | Generation 1 | +-------+--------+--------------------------+ | 16 | 8 | Generation 2 | +-------+--------+--------------------------+ | 24 | 4 | Number of TOC entries | +-------+--------+--------------------------+ | 28 | 4 | Flags | +-------+--------+--------------------------+ | 32 | 4 | Process identifier (PID) | +-------+--------+--------------------------+ | 36 | 4 | Cluster identifier | +-------+--------+--------------------------+ The generation numbers are timestamps at the time of file creation, and must match for the file to be considered by the MMV PMDA. The flags can specify ways in which the client would like the MMV PMDA to behave - e.g. the MMV_FLAG_PROCESS flag specifies that only if the process identified by PID is currently running should those values be exported. Finally, if set, the cluster identifier is a hint to the MMV PMDA as to what cluster should be used with this application when forming the individual metric identifiers. A performance metric identifier (see PMDA(3)) consists of the PMDA domain number, the cluster number, and the individual item numbers described in the Metrics section. The header is followed by at least 2 TOC sections: one section for metrics and another for values. The TOC section has the following for- mat: +-------+--------+---------------------------------------------+ |Offset | Length | Value | +-------+--------+---------------------------------------------+ | 0 | 4 | Section Type (see mmv_stats.h) | +-------+--------+---------------------------------------------+ | 4 | 4 | Number of entries in the section | +-------+--------+---------------------------------------------+ | 8 | 8 | Section's offset from the start of the file | +-------+--------+---------------------------------------------+ The section types are: 1: Indoms (instance domain definitions) 2: Instances 3: Metrics (metric definitions) 4: Values 5: String The only mandatory sections are Metrics and Values. Indoms and Instances sections only appear if there are metrics with multiple instances. String sections only appear if there are metrics with string values, or when Metrics or Indoms are defined with help text. The entries in the Indoms section have the following format: +-------+--------+--------------------------------------+ |Offset | Length | Value | +-------+--------+--------------------------------------+ | 0 | 4 | Unique serial number for this domain | +-------+--------+--------------------------------------+ | 4 | 4 | Number of entries in the domain | +-------+--------+--------------------------------------+ | 8 | 8 | Offset to first instance | +-------+--------+--------------------------------------+ | 16 | 8 | Short help text offset | +-------+--------+--------------------------------------+ | 24 | 8 | Long help text offset | +-------+--------+--------------------------------------+ The entries in the Instances section have the following format: +-------+--------+-------------------------------+ |Offset | Length | Value | +-------+--------+-------------------------------+ | 0 | 8 | Offset into the indom section | +-------+--------+-------------------------------+ | 8 | 4 | Unused padding (zero filled) | +-------+--------+-------------------------------+ | 12 | 4 | Internal instance identifier | +-------+--------+-------------------------------+ | 16 | 64 | External instance identifier | +-------+--------+-------------------------------+ The entries in the Metrics section have the following format: +-------+--------+-------------------------------+ |Offset | Length | Value | +-------+--------+-------------------------------+ | 0 | 64 | Metric Name | +-------+--------+-------------------------------+ | 64 | 4 | Metric Item (see PMDA(3)) | +-------+--------+-------------------------------+ | 68 | 4 | Metric Type (see mmv_stats.h) | +-------+--------+-------------------------------+ | 72 | 4 | Semantics (see PMAPI(3)) | +-------+--------+-------------------------------+ | 76 | 4 | Dimensions (see PMAPI(3)) | +-------+--------+-------------------------------+ | 80 | 4 | Instance Domain ID | +-------+--------+-------------------------------+ | 84 | 4 | Unused padding (zero filled) | +-------+--------+-------------------------------+ | 88 | 8 | Short help text offset | +-------+--------+-------------------------------+ | 96 | 8 | Long help text offset | +-------+--------+-------------------------------+ The entries in the Values section have the following format: +-------+--------+------------------------------------+ |Offset | Length | Value | +-------+--------+------------------------------------+ | 0 | 8 | pmAtomValue (see PMAPI(3)) | +-------+--------+------------------------------------+ | 8 | 8 | Extra space for STRING and ELAPSED | +-------+--------+------------------------------------+ | 16 | 8 | Offset into the Metrics section | +-------+--------+------------------------------------+ | 24 | 8 | Offset into the Instances section | +-------+--------+------------------------------------+ Each entry in the strings section is a 256 byte character array, containing a single NULL-terminated character string. So each string has a maximum length of 256 bytes, which includes the terminating NULL. SEE ALSO
PCPIntro(1), PMAPI(3), mmv_stats_init(3), pcp.conf(5) and pcp.env(5). Performance Co-Pilot MMV(5)
All times are GMT -4. The time now is 02:06 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy