Sponsored Content
Top Forums Shell Programming and Scripting Sort the file contents in each group....print the group title as well Post 302447893 by prash184u on Tuesday 24th of August 2010 03:32:12 PM
Old 08-24-2010
Sort the file contents in each group....print the group title as well

I've this file and need to sort the data in each group

File would look like this ...

cat file1.txt
Code:
Reason : ABC
12345-0023
32123-5400
32442-5333

Reason : DEF
42523-3453
23345-3311

Reason : HIJ
454553-0001

I would like to sort each group on the last 4 fileds and print them in the same group

I want the file to look like this

Code:
Reason : ABC
12345-0023
32442-5333
32123-5400


Reason : DEF
23345-3311
42523-3453


Reason : HIJ
454553-0001

I tried using the sort command but it would mess up the group.. any hints or ideas would be appriciated too....

Thanks in advance
 

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
gen_udp(3erl)						     Erlang Module Definition						     gen_udp(3erl)

NAME
gen_udp - Interface to UDP sockets DESCRIPTION
The gen_udp module provides functions for communicating with sockets using the UDP protocol. DATA TYPES
ip_address() see inet(3erl) posix() see inet(3erl) socket() as returned by open/1,2 EXPORTS
open(Port) -> {ok, Socket} | {error, Reason} open(Port, Options) -> {ok, Socket} | {error, Reason} Types Port = 0..65535 Options = [Opt] Opt -- see below Socket = socket() Reason = posix() Associates a UDP port number ( Port ) with the calling process. The available options are: list : Received Packet is delivered as a list. binary : Received Packet is delivered as a binary. {ip, ip_address()} : If the host has several network interfaces, this option specifies which one to use. {fd, int()} : If a socket has somehow been opened without using gen_udp , use this option to pass the file descriptor for it. inet6 : Set up the socket for IPv6. inet : Set up the socket for IPv4. Opt : See inet:setopts/2 . The returned socket Socket is used to send packets from this port with send/4 . When UDP packets arrive at the opened port, they are delivered as messages: {udp, Socket, IP, InPortNo, Packet} Note that arriving UDP packets that are longer than the receive buffer option specifies, might be truncated without warning. IP and InPortNo define the address from which Packet came. Packet is a list of bytes if the option list was specified. Packet is a binary if the option binary was specified. Default value for the receive buffer option is {recbuf, 8192} . If Port == 0 , the underlying OS assigns a free UDP port, use inet:port/1 to retrieve it. send(Socket, Address, Port, Packet) -> ok | {error, Reason} Types Socket = socket() Address = string() | atom() | ip_address() Port = 0..65535 Packet = [char()] | binary() Reason = not_owner | posix() Sends a packet to the specified address and port. The Address argument can be either a hostname, or an IP address. recv(Socket, Length) -> {ok, {Address, Port, Packet}} | {error, Reason} recv(Socket, Length, Timeout) -> {ok, {Address, Port, Packet}} | {error, Reason} Types Socket = socket() Length = int() Address = ip_address() Port = 0..65535 Packet = [char()] | binary() Timeout = int() | infinity Reason = not_owner | posix() This function receives a packet from a socket in passive mode. The optional Timeout parameter specifies a timeout in milliseconds. The default value is infinity . controlling_process(Socket, Pid) -> ok Types Socket = socket() Pid = pid() Assigns a new controlling process Pid to Socket . The controlling process is the process which receives messages from the socket. close(Socket) -> ok | {error, Reason} Types Socket = socket() Reason = not_owner | posix() Closes a UDP socket. Ericsson AB kernel 2.14.3 gen_udp(3erl)
All times are GMT -4. The time now is 08:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy