Sponsored Content
Full Discussion: Sort in AWK
Top Forums Shell Programming and Scripting Sort in AWK Post 302346872 by eknryan on Monday 24th of August 2009 09:54:04 AM
Old 08-24-2009
Sort in AWK

Hi,
I usually use Access to sort data however for some reason its not working. Our systems guys and myself cannot figure it out so ive tried to use AWK to do the sorting. The file is made up of single lines in the format

Code:
L78-60/6:0-1480,195-1480,250-1552,500-1718,750-1862,1000-1985,1250-2102,1500-2235,1750-2406,2000-2600,2250-2763,2500-2907,2750-3086,3000-3310,3250-3496,3500-3661,3750-3789/
L76-37/24:0-1480,71-1480,250-1654,500-1857,750-2003,1000-2144,1250-2388,1500-2636,1750-2780,2000-2884,2250-3129,2500-3372,2750-3547,3000-3675,3250-3773,3500-3851,3750-3928/
L76-28/24:0-1480,54-1480,250-1717,500-1813,750-1964,1000-2101,1250-2234,1500-2399,1750-2556,2000-2684,2250-2843,2500-3034,2750-3171,3000-3300,3250-3409,3500-3585,3750-3794/

I have been using sort -n to sort by 1st field (FS= /) but I can get nothing.

Can anybody help?

Thanks Smilie
Ryan
 

10 More Discussions You Might Find Interesting

1. Homework & Coursework Questions

awk sort help

1. The problem statement, all variables and given/known data: I dont know what I do wrong, I am trying to create shell programming database: I have this command first: && > $fname ... echo $Name:$Surname:$Agency:$Tel:$Ref: >> $fname then I have echo " Name Surname Agency Tel... (2 Replies)
Discussion started by: jeht
2 Replies

2. Shell Programming and Scripting

Sort and count using AWK

Hi, I've a fixed width file where I need to count the number of patterns from each line between characters 1 to 15 . so can we sort them and get a count for each pattern on the file between 1 to 15 characters. 65795648617522383763831552 410828003265795648 6175223837... (5 Replies)
Discussion started by: rudoraj
5 Replies

3. Shell Programming and Scripting

match and sort using awk

Hello, Is it possible to do match and sort the data from two fields in a file using awk? Like for example: input apple cat in rat out sky cat pen rat ball sky cpu pen linux ball unix cpu paper linux phone unix paper phone (8 Replies)
Discussion started by: avatar_007
8 Replies

4. Shell Programming and Scripting

Awk sort and unique

Input file --------- 12:name1:|host1|host1|host2|host1 13:name2:|host1|host1|host2|host3 14:name3: ...... Required output --------------- 12:name1:host1(2)|host1(1) 13:name2:host1(2)|host2(1)|host3(1) 14:name3: where (x) - Count how many times field appears in last column ... (3 Replies)
Discussion started by: greycells
3 Replies

5. Shell Programming and Scripting

awk array sort

I have a file as below Input File: 5/11/2012, dir1, 134 5/11/2012, dir2, 2341 5/11/2012, dir3, 2134 5/11/2012, dir4, 2334 5/12/2012, dir1, 234 5/12/2012, dir2, 2341 5/12/2012, dir3, 2334 5/13/2012, dir1, 234 5/13/2012, dir2, 2341 5/13/2012, dir3, 2334 5/13/2012, dir4, 21134 Now... (6 Replies)
Discussion started by: chakrapani
6 Replies

6. Shell Programming and Scripting

awk sort

input file abc1 abc23 abc12 abc15 output abc1 abc12 abc15 abc23 (9 Replies)
Discussion started by: yanglei_fage
9 Replies

7. UNIX for Dummies Questions & Answers

Sort and vectors on awk

Well, i have a script and it makes a txt like this : Caps 12 cans 9 cols 10 my print line is something like this for(i in a) print i, a; i have to order the txt from higher to low like: (6 Replies)
Discussion started by: matius_88
6 Replies

8. Shell Programming and Scripting

Need help on horizontal sort with AWK

dear friends.. i have data : 20130603;ABCD;ABCD1;14030;51271;0.000;0.000;21.000 20130603;ABCD;ABCD2;14030;51272;4853.000;53591.000;40539.000 20130603;ABCD;ABCD3;14030;51273;38024.000;385068.000;396424.000 20130603;ABCD;EFGH1;14030;51334;285879.000;563964.000;141780.000... (4 Replies)
Discussion started by: buncit8
4 Replies

9. Shell Programming and Scripting

Sort String using awk

Hi, I need help to sort string using awk. I don't want to use sed or perl as I want to add this functionality in my existing awk script Basically I have a variable in AWK which is string with comma separated value. I want to sort that string before using that variable in further processing for... (10 Replies)
Discussion started by: rocky.community
10 Replies

10. Shell Programming and Scripting

Sort by first row - awk

how can i sort the table based on first row? thanks in advance input name d b c a l l1 l2 l3 l4 l1 1 2 3 4 l2 2 2 2 1 l3 1 1 2 2ouput name a b c d l1 l4 ... (4 Replies)
Discussion started by: quincyjones
4 Replies
METASYS(8)							    NUT Manual								METASYS(8)

NAME
metasys - Driver for Meta System UPS equipment NOTE
This man page only documents the hardware-specific features of the metasys driver. For information about the core driver, see nutupsdrv(8). SUPPORTED HARDWARE
The metasys driver was written with the "Meta System UPS Protocol Rev.1.12" kindly supplied from Meta System. The driver should support all the common features of the ups models: o HF Line (/2) 1-8 boards o HF Millennium (810, 820) o HF TOP Line (910, 920, 930, 940, 950, 970, 980) o ECO Network (750, 1000, 1050, 1500, 1800, 2000, 2100, 2500, 3000) o ECO (305, 308, 311, 511, 516, 519, 522, SX, SXI) o ally HF (800, 1000, 1250, 1600, 2000, 2500) o Megaline (1250, 2500, 3750, 5000, 6250, 7500, 8750, 10000) CABLING
The needed cable is a standard pin-to-pin serial cable with at least pins 2, 3, and 5 (on DB9 connector) connected. EXTRA ARGUMENTS
This driver supports no extra arguments from ups.conf(5). BUGS
This driver has been tested on Meta System HF Millennium 820 and ally HF 1000 only. Any information about the use of the driver with the other listed UPS are really welcome. AUTHOR
Fabio Di Niro <blaxwan@users.sourceforge.net> SEE ALSO
The core driver: nutupsdrv(8) Internet resources: The NUT (Network UPS Tools) home page: http://www.networkupstools.org/ Network UPS Tools 05/21/2012 METASYS(8)
All times are GMT -4. The time now is 06:48 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy