Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need help on horizontal sort with AWK
Top Forums Shell Programming and Scripting Need help on horizontal sort with AWK Post 302817225 by shamrock on Wednesday 5th of June 2013 12:18:53 PM
Old 06-05-2013
Here's an awk script you can try...
Code:
awk '{
   n = split($0, a, ";")
   for (i = 1; i < (n + 1) - 6 ; i++)
       for (j = 6; j < (n + 1) - i; j++)
           if (a[j] < a[j+1]) {
              t = a[j]
              a[j] = a[j+1]
              a[j+1] = t
           }
   for (k = 1; k <= n; k++)
       printf("%s%s", a[k], k < n ? ";" : "\n")
}' file

Caveat is that...it assumes that part of the line that needs sorting starts at $6.
Last edited by shamrock; 06-05-2013 at 01:31 PM..
This User Gave Thanks to shamrock For This Post:
buncit8
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

help for saving vertical datas to horizontal with "awk" or "cut"

hi, i have a file having datas like that ./a.txt 12344 12345 12346 12347 ..... ..... ... i want to save this datas to another file like that ./b.txt 12344 12345 12346 12347 ... ... ... i think awk can make this but how? :) waiting for ur help. (3 Replies)
Discussion started by: mercury
3 Replies

2. 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

3. Shell Programming and Scripting

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 ... (4 Replies)
Discussion started by: eknryan
4 Replies

4. 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

5. Shell Programming and Scripting

Need perl or shell script to sort vertical lines to horizontal line in csv format

Need perl or shell script to sort vertical lines to horizontal line in csv format My file like below ------------------------- ================================================================================ PATH PINKY1000#I1-1-ZENTA1000-2#I7-1-ASON-SBR-UP-943113845 ... (4 Replies)
Discussion started by: sreedhargouda.h
4 Replies

6. Shell Programming and Scripting

awk - horizontal and vertical text extraction

Hi, I need some help in getting extracting the specific horizontal and vertical texts in a single line. I am trying to extract few of the parameters from a config file. Your help is appreciated. Desired Output ---------------- Pool members members ... (4 Replies)
Discussion started by: pratheeshp
4 Replies

7. Shell Programming and Scripting

awk Help: Horizontal to Vertical print with pattern match

Hi AWK Experts, Following is the data : BRH113 DD AA HH CA DD DD AA HH BRH091 A4 A6 AH H7 67 HH J8 9J BRH0991 AA D8 C23 V5 H7 BR2 BRH991 AA HH GG5 BT0 JJ0 I want the output to be alligned with the pattern matching "BRH" inthe line. The output should be look like: A]... (4 Replies)
Discussion started by: rveri
4 Replies

8. Shell Programming and Scripting

awk in horizontal and vertical math

Based on input ail,UTT,id1_0,COMBO,21,24,21,19,85 al,UTHAST,id1_0,COMBO,342,390,361,361,1454 and awk code as awk -F, '{ K=0; for(i=NF; i>=(NF-4); i--) { K=K+$i; J=J+$i;} { print K } } END { for ( l in J ) printf("%s ",J); }' I'm trying to add columns and lines in single line. line... (6 Replies)
Discussion started by: busyboy
6 Replies

9. Shell Programming and Scripting

Script awk vertical to horizontal with some condition

hi all.. i have problem, right now i want to processing some data with input like this BIMAB ACF-0168 QTS-0465 QUA 2013-08-17 14:16:09.34 ** ALAR ORX -004 NDORIDUNGGA (21943) 7745 ABOVE DEFINED 02 00 01 00 00 00 01 00 00 01 03... (12 Replies)
Discussion started by: buncit8
12 Replies

10. Shell Programming and Scripting

awk to change comma separated line to horizontal

I am trying to change a file that looks like this: file, announcement,date, server, server01, server02, server06, file04, rec01, rec04, rec03... etc into a vertical file like this: file announcement date server server01 server02 server06 The file does not have to be sorted... (5 Replies)
Discussion started by: newbie2010
5 Replies

LEARN ABOUT OSF1

temporary

Temporary(4)						     Kernel Interfaces Manual						      Temporary(4)

NAME

       Temporary - Stores data files during transfers to remote systems

SYNOPSIS

       /usr/spool/uucp/SystemName/TM.xxPID.000

DESCRIPTION

       The  uucp  Temporary  (TM.*) files store data files during transfers to remote systems.	After a Data (D.*) file is transferred to a remote
       system by the uucico daemon, the uucp program places it in a subdirectory of the uucp spooling directory named  /usr/spool/uucp/SystemName,
       where  the SystemName directory is named for the computer that is transmitting the file.  The uucp program creates a temporary data file to
       hold the original data file.

       The full pathname of the temporary data file is in the following format: /usr/spool/uucp/SystemName/TM.xxPID.000

       where the SystemName directory is named for the computer that is sending the file, and TM.xxPID.000 is the name of the file;  for  example,
       TM.00451.000.  The PID variable is the process ID of the job.

FILES

       Describes accessible remote systems Contains uucp command, data, and execute files Contain data to be transferred.  Contain files that uucp
       has transferred

RELATED INFORMATION

       Daemons: uucico(8)

       Commands: uucp(1), uudemon.cleanu(4), uupick(1), uuto(1), uux(1) delim off

																      Temporary(4)
All times are GMT -4. The time now is 10:51 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy