Sponsored Content
Full Discussion: Sorting By Column
Top Forums Shell Programming and Scripting Sorting By Column Post 302407196 by john123 on Wednesday 24th of March 2010 07:56:09 PM
Old 03-24-2010
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 specific column.

sample records of my file is:

Code:
Toshiba:8000:2000:silver:3
Samsung:6000:2000:gold:5

I want to be able to sort on the second column could someone please provide me with the code that will do this through pico.
 

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 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... (1 Reply)
Discussion started by: krishnan_6015@y
1 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
indicator(1F)							   FMLI Commands						     indicator(1F)

NAME
indicator - display application specific alarms and/or the "working" indicator SYNOPSIS
indicator [-b [n]] [-c column] [-l length] [-o] [-w] [string]... DESCRIPTION
The indicator function displays application specific alarms or the "working" indicator, or both, on the FMLI banner line. The argument string is a string to be displayed on the banner line, and should always be the last argument given. Note that string is not automatically cleared from the banner line. OPTIONS
-bn The -b option rings the terminal bell n times, where n is an integer from 1 to 10. The default value is 1. If the terminal has no bell, the screen is flashed instead, if possible. -c column The -c option defines the column of the banner line at which to start the indicator string. The argument column must be an integer from 0 to DISPLAYW-1. If the -c option is not used, column defaults to 0 . -l length The -l option defines the maximum length of the string displayed. If string is longer than length characters, it will be trun- cated. The argument length must be an integer from 1 to DISPLAYW. If the -l option is not used, length defaults to DISPLAYW. Note that if string doesn't fit it will be truncated. -o The -o option causes indicator to duplicate its output to stdout . -w The -w option turns on the "working" indicator. EXAMPLES
Example 1 A sample output of the indicator command. When the value entered in a form field is invalid, the following use of indicator will ring the bell three times and display the word WRONG starting at column 1 of the banner line. invalidmsg=`indicator -b 3 -c 1 "WRONG"` To clear the indicator after telling the user the entry is wrong: invalidmsg=`indicator -b 9 -c 1 "WRONG"; sleep 3; indicator -c 1 " "` In this example the value of invalidmsg (in this case the default value Input is not valid), still appears on the FMLI message line. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWcsu | +-----------------------------+-----------------------------+ SEE ALSO
attributes(5) SunOS 5.11 5 Jul 1990 indicator(1F)
All times are GMT -4. The time now is 03:39 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy