Visit Our UNIX and Linux User Community


awk sort help

 
Thread Tools Search this Thread
Homework and Emergencies Homework & Coursework Questions awk sort help
# 1  
Old 07-21-2009
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:
[ ! -f $fname ] && > $fname
...
echo $Name:$Surname:$Agency:$Tel:$Ref: >> $fname

then I have
echo " Name Surname Agency Tel email Ref"
echo ================================================
...

2. Relevant commands, code, scripts, algorithms:
sort -t : +1 $fname | awk -F '{printf ( "%-8.8s%-9.9s%-9.9s%-11.11s%-8.8s%-9.9s%" $1,$2)}'



3. The attempts at a solution (include all code and scripts):
I have tried with and without the FS "-F" the error was." sort warning : "+number" syntax is deprecated please use "-k number" only with -F the error is above the table and without -F it is below the table.


4. School (University) and Course Number:

---------- Post updated at 08:22 AM ---------- Previous update was at 07:27 AM ----------

Hi All,

Thanks, I have found the solution:

I have just replaced the +1 with -k 1 and it worked perfectly no error but it will not show the contents of the database..
Anyone can help ?

Cheers
# 2  
Old 07-21-2009
First check whether you get sorted output using sort command without awk, then try awk.

Code:
awk -F '{printf ( "%-8.8s%-9.9s%-9.9s%-11.11s%-8.8s%-9.9s%" $1,$2)}'

May be you needed...
awk -F":" '{printf ( "%-8.8s%-9.9s%-9.9s%-11.11s%-8.8s%-9.9s%", $1,$2,$3,$4,$5,$6)}'

have a look at awk document.

Last edited by rakeshawasthi; 07-21-2009 at 11:11 AM.. Reason: Spelling mistake
# 3  
Old 07-22-2009
Tnx Rakeshawasthi,

Tried ...awk -F":" ... got error saying: awk: runtime error: not enough arguments passed to printf(....

When however I added "\n" problem solved..

Thank you very very much for your help

Previous Thread | Next Thread
Test Your Knowledge in Computers #552
Difficulty: Medium
If variable i has the value 10, after x = 5 + (++i); the value of x after this code is 15.
True or False?

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

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

Featured Tech Videos