Sponsored Content
Top Forums Shell Programming and Scripting Sort the file contents in each group....print the group title as well Post 302447906 by ygemici on Tuesday 24th of August 2010 04:05:17 PM
Old 08-24-2010
MySQL

Code:
while read -r l; do if [[ "$l" != "" ]] ; then echo "$l">>tmp ; else sort -t- -k2n tmp; echo "" ; rm -f tmp ; fi ; done<infile ; more tmp ; rm -f tmp
Reason : ABC
12345-0023
32442-5333
32123-5400
 
Reason : DEF
23345-3311
42523-3453
 
Reason : HIJ
454553-0001

This User Gave Thanks to ygemici For This Post:
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Sort cmd to get GROUP BY?

Is there any way using the sort command to get something like a GROUP BY clause? I'm trying to sort through race_event records and group them by those individuals that raced together in the same race on the same date at the same track, but i run into a problem when there were days when the track... (6 Replies)
Discussion started by: RacerX
6 Replies

2. Shell Programming and Scripting

awk help required to group output and print a part of group line and original line

Hi, Need awk help to group and print lines to format the output as shown below INPUT FORMAT set echo on set heading on set spool on /* SCHEMA1 */ CREATE TABLE T1; /* SCHEMA1 */ CREATE TABLE T2; /* SCHEMA1 */ CREATE TABLE T3; /* SCHEMA1 */ CREATE TABLE T4; /* SCHEMA1 */ CREATE TABLE T5;... (5 Replies)
Discussion started by: rajan_san
5 Replies

3. Shell Programming and Scripting

Sort, group rows

I wrote script in bash which generates this report: User1,admin,rep,User2,shell,path1,x1,r1 User2,admin,rep,User7,shell,path1,x1,r1 User3,admin,rep,User4,shell,path1,x1,r1 User4,admin,rep,User3,shell,path1,x1,r1 User5,admin,rep,User1,shell,path1,x1,r1 User6,admin,rep,User5,shell,path1,x1,r1... (6 Replies)
Discussion started by: patrykxes
6 Replies

4. Shell Programming and Scripting

awk - sort, then print the high value for each group

Hi @ all I'm trying to achive to this problem, I've a 2-column composed file as the following: 192.168.1.2 2 192.168.1.3 12 192.168.1.2 4 192.168.1.4 3 cpc1-swan1-2-3-cust123.swan.cable.ntl.com 4 192.168.1.3 5 192.168.1.2 10 192.168.1.4 8... (8 Replies)
Discussion started by: m4rco-
8 Replies

5. Shell Programming and Scripting

Merge group numbers and add a column containing group names

Hi All I do have a file like this with 6 columns. Groups of data merge together and the group number is indicated above each group. 1 1 12 26 289 3.2e-027 GCGTATGGCGGC 2 12 26 215 6.7e+006 TTCCACCTTTTG 3 9 26 175 ... (1 Reply)
Discussion started by: Lucky Ali
1 Replies

6. Shell Programming and Scripting

Sort Data by Group !

Hello, I have a file and i want to sort by third column and extract the three top lines of each group, it is determined by the second column (144, 89, 55, etc). Could you please help me with the appropiate awk shell script XLY-XLP 144 0.592772 XLY-XLE 144 0.798121 ... (3 Replies)
Discussion started by: csierra
3 Replies

7. Shell Programming and Scripting

need a one liner to grep a group info from /etc/group and use that result to search passwd file

/etc/group tiadm::345:mk789,po312,jo343,ju454,ko453,yx879,iy345,hn453 bin::2:root,daemon sys::3:root,bin,adm adm::4:root,daemon uucp::5:root /etc/passwd mk789:x:234:1::/export/home/dummy:/bin/sh po312:x:234:1::/export/home/dummy:/bin/sh ju454:x:234:1::/export/home/dummy:/bin/sh... (6 Replies)
Discussion started by: chidori
6 Replies

8. UNIX for Dummies Questions & Answers

How to create a volume group, logical volume group and file system?

hi, I want to create a volume group of 200 GB and then create different file systems on that. please help me out. Its becomes confusing when the PP calculating PP. I don't understand this concept. (2 Replies)
Discussion started by: kamaldev
2 Replies

9. Programming

Sql ORA-00937: not a single-group group function

I'm trying to return only one row with the highest value for PCT_MAX_USED. Any suggestions? When I add this code, I get the ORA-00937 error. trunc(max(decode( kbytes_max, 0, 0, (kbytes_alloc/kbytes_max)*100))) pct_max_used This is the original and returns all rows. select (select... (3 Replies)
Discussion started by: progkcp
3 Replies
NEWGRP(1)						    BSD General Commands Manual 						 NEWGRP(1)

NAME
newgrp -- change to a new primary group SYNOPSIS
newgrp [-l] [group] DESCRIPTION
The newgrp command changes a user to a new primary group (real and effective group ID) by starting a new shell. The user remains logged in and the current directory and file creation mask remain unchanged. The user is always given a new shell even if the primary group change fails. The newgrp command accepts the following options: -l The environment is changed to what would be expected if the user actually logged in again. This simulates a full login. The group is a group name or non-negative numeric group ID from the group database. The real and effective group IDs are set to group or the group ID associated with the group name. If group is not specified, newgrp restores the user's real and effective group IDs to the user's primary group specified in the password database. The user's supplementary group IDs are restored to the set specified for the user in the group database. If the user is not a member of the specified group, and the group requires a password, the user will be prompted for the group password. FILES
/etc/group The group database /etc/master.passwd The user database /etc/passwd A Version 7 format password file EXIT STATUS
If a new shell is started the exit status is the exit status of the shell. Otherwise the exit status will be >0. SEE ALSO
csh(1), groups(1), login(1), sh(1), su(1), umask(2), group(5), passwd(5), environ(7) STANDARDS
The newgrp command conforms to IEEE Std 1003.1-2001 (``POSIX.1''). HISTORY
A newgrp command appeared in Version 6 AT&T UNIX. A newgrp command appeared in NetBSD 5.0. BUGS
There is no convenient way to enter a password into /etc/group. The use of group passwords is strongly discouraged since they are inherently insecure. It is not possible to stop users from obtaining the encrypted password from the group database. BSD
June 6, 2007 BSD
All times are GMT -4. The time now is 09:13 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy