Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Substitute to GROUP BY function
Top Forums Shell Programming and Scripting Substitute to GROUP BY function Post 94604 by rinku11 on Monday 2nd of January 2006 09:02:59 AM
Old 01-02-2006
Substitute to GROUP BY function
Hi All,
I really need a help on this thing. Most of us are aware about the group by function in Oracle. Do we have a substitute ( not necessarily a single line command) to it in Unix?
Let me put it this way.
I have a file whose content is like
file1-:

ID1,ID2,ID3,ID4,ID5
1,2,3,123,5
1,5,4,154,2
1,2,3,123,4
2,3,5,235,3
1,5,4,154,1
2,3,5,235,2
3,2,5,325,5
2,3,5,235,6

The first line is not the content of the file. Rather I put that to identify the the fields. ID3 is nothing but "ID1||ID2||ID3".
Now we need to sort the file1 based on ID4 and then sum up the ID4 values for the same ID3. This sum-ed up value will be ID5. And ID6 will be the number of records involved in the group.
My final output should be like
1,2,3,123,9,2
1,5,4,154,3,2
2,3,5,235,11,3
3,2,5,325,5,1
Is not this what the GROUP BY function performs in Oracle? If my words are confusing then sorry for that. But the i/p and o/p files are self explanatory. Ain't they?
Thanks in advance for any help.

Many regards,
Rinku..
 

9 More Discussions You Might Find Interesting

1. Solaris

entry in /etc/group too long - problem using sudo with %group

hi folks, I've been googling for quite some time, but still can't find anything near it...my problem is the following: for useradministration in our company we are using ssh/sudo, now whenever I try to add users (we have quite a number of users) with useradd -G groupname for secondary group I... (4 Replies)
Discussion started by: poli
4 Replies

2. Shell Programming and Scripting

sed substitute / for \ : error "Function can not be parsed"

Hello all, I have a weird issue when trying to substitute the slashes into backslashes. If I execute this on the command-line (bash / ksh) I get the path correctly translated with backslashes instead of slashes. > echo $PWD | sed 's/\//\\/g' However, when I put this in my script to... (3 Replies)
Discussion started by: candyflip2000
3 Replies

3. Shell Programming and Scripting

Merge group numbers and add a column containing group names

I have a file in the following format. Groups of data merge together and the group number is indicated above each group. 1 adrf dfgr dfg 2 dfgr dfgr 3 dfef dfr fd 4 fgrt fgr fgg 5 fgrt fgr (3 Replies)
Discussion started by: Lucky Ali
3 Replies

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

5. Shell Programming and Scripting

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

6. AIX

Adding a Volume Group to an HACMP Resource Group?

Hi, I have a 2 node Cluster. Which is working in active/passive mode (i.e Node#1 is running and when it goes down the Node#2 takes over) Now there's this requirement that we need a mount point say /test that should be available in active node #1 and when node #1 goes down and node#2 takes... (6 Replies)
Discussion started by: aixromeo
6 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. Shell Programming and Scripting

Awk-using group function

Hi, I have file with below format and sample data - File is pipe delimited Col1|col2|Account|Bal1|Bal2 1|2|1|10|5 1|2|2|10|2 1|3|3|10|3 I want output as SUM|1|2|2|20|7 SUM|1|3|1|10|3 Can anyone give me awk command (4 Replies)
Discussion started by: sanranad
4 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

LEARN ABOUT PHP

id3_set_tag

ID3_SET_TAG(3)								 1							    ID3_SET_TAG(3)

id3_set_tag - Update information stored in an ID3 tag

SYNOPSIS

       bool id3_set_tag (string  $filename, array  $tag, [int  $version = ID3_V1_0])

DESCRIPTION

       id3_set_tag(3) is used to change the information stored of an ID3 tag. If no tag has been present, it will be added to the file.

PARAMETERS

	      o $filename
		- The path to the MP3 file  Instead of a filename you may also pass a valid stream resource

	      o $tag
		- An associative array of tag keys and values  The following keys may be used in the associative array:

	      Keys in the associative array

	      +--------+--------------------------------------+---+
	      |  key   |				      |   |
	      |        |				      |   |
	      |        |	    possible value	      |   |
	      |        |				      |   |
	      |        |	 available in version	      |   |
	      |        |				      |   |
	      +--------+--------------------------------------+---+
	      | title  |				      |   |
	      |        |				      |   |
	      |        | string with maximum of 30 characters |   |
	      |        |				      |   |
	      |        |	      v1.0, v1.1	      |   |
	      |        |				      |   |
	      |artist  |				      |   |
	      |        |				      |   |
	      |        | string with maximum of 30 characters |   |
	      |        |				      |   |
	      |        |	      v1.0, v1.1	      |   |
	      |        |				      |   |
	      | album  |				      |   |
	      |        |				      |   |
	      |        | string with maximum of 30 characters |   |
	      |        |				      |   |
	      |        |	      v1.0, v1.1	      |   |
	      |        |				      |   |
	      | year   |				      |   |
	      |        |				      |   |
	      |        |	       4 digits 	      |   |
	      |        |				      |   |
	      |        |	      v1.0, v1.1	      |   |
	      |        |				      |   |
	      | genre  |				      |   |
	      |        |				      |   |
	      |        |   integer value between 0 and 147    |   |
	      |        |				      |   |
	      |        |	      v1.0, v1.1	      |   |
	      |        |				      |   |
	      |comment |				      |   |
	      |        |				      |   |
	      |        | string with maximum of 30 characters |   |
	      |        | (28 in v1.1)			      |   |
	      |        |				      |   |
	      |        |	      v1.0, v1.1	      |   |
	      |        |				      |   |
	      | track  |				      |   |
	      |        |				      |   |
	      |        |      integer between 0 and 255       |   |
	      |        |				      |   |
	      |        |		 v1.1		      |   |
	      |        |				      |   |
	      +--------+--------------------------------------+---+
	      o $version
		- Allows you to specify the version of the tag as MP3 files may contain both, version 1.x and version 2.x tags

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      id3_set_tag(3) example

	      <?php
	      $data = array(
			    "title" => "Re:Start",
			    "artist" => "Re:Legion",
			    "comment" => "A nice track"
			   );
	      $result = id3_set_tag( "path/to/example.mp3", $data, ID3_V1_0 );
	      if ($result === true) {
		  echo "Tag successfully updated
";
	      }
	      ?>

	       If the file is writable, this will output:

	      Tag successfully updated

NOTES

       Note

	       Currently id3_set_tag(3) only supports version 1.0 and 1.1.

SEE ALSO

       id3_remove_tag(3), id3_get_tag(3), id3_get_version(3).

PHP Documentation Group 													    ID3_SET_TAG(3)
All times are GMT -4. The time now is 09:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy