Awk-using group function Post: 302689337

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

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

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

3. Shell Programming and Scripting

Awk-Group count of field

Hi, Suppose if i am having a file with following records as given below. 5555 6756 5555 4555 4555 6767 how can i get the count of each record using AWK. Eg:5555 count should be 2 4555 count should be 2 6767 count should be 1 ...

4. Shell Programming and Scripting

awk group by

Hi I have a file in this format: ... 04/May/2009 16 04/May/2009 1 05/May/2009 3 05/May/2009 5 06/May/2009 1 06/May/2009 3 ... I need to sum for every day, What is the best way? Thanks all

5. Shell Programming and Scripting

Awk problem: How to express the single quote(') by using awk print function

Actually I got a list of file end with *.txt I want to use the same command apply to all the *.txt Thus I try to find out the fastest way to write those same command in a script and then want to let them run automatics. For example: I got the file below: file1.txt file2.txt file3.txt...

6. Shell Programming and Scripting

Group by using awk

Hi All, I have a file in the following format... ***************************************************** 11/10/27 12:09 : Input Record 11/10/27 12:10 : Input Record 11/10/27 12:10 : Input Record 11/10/27 12:10 : Input Record 11/10/27 12:10 : Input Record 11/10/27 12:10 : Input...

7. Shell Programming and Scripting

awk - how do i get the last row of a group

How do i print the last record of a group in a file ? For example, I have a file like this : cat txt cucm1,location1,1,2,3 cucm2,location1,3,4,5 cucm1,location1,10,20,30 cucm2,location2,30,40,50 I am expecting a command that would print the last record of the group. For example, ...

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

9. Shell Programming and Scripting

Need help on awk for printing the function name inside each function

Hi, I am having script which contains many functions. Need to print each function name at the starting of the function. Like below, functionname() { echo "functionname" commands.... } I've tried like below, func=`grep "()" scriptname | cut -d "(" -f1` for i in $func do nawk -v...

10. UNIX for Beginners Questions & Answers

Group and search using awk

file: Data has to be grouped on 1st field; And in each group, print 2nd field IF 1st field doesn't match with any of the values in 2nd field.. o/p to be: I ended up writing as below, any help ?? awk -F, '!($1 in a){a++;}END{for (i in a)print i}' file

LEARN ABOUT CENTOS

funindex

funindex(1)							SAORD Documentation						       funindex(1)

NAME

       funindex - create an index for a column of a FITS binary table

SYNOPSIS

       funindex <switches>  <iname> [oname]

OPTIONS

	 NB: these options are not compatible with Funtools processing. Please
	 use the defaults instead.
	 -c	   # compress output using gzip"
	 -a	   # ASCII output, ignore -c (default: FITS table)"
	 -f	   # FITS table output (default: FITS table)"
	 -l	   # long output, i.e. with key value(s) (default: long)"
	 -s	   # short output, i.e. no key value(s) (default: long)"

DESCRIPTION

       The funindex script creates an index for the specified column (key) by running funtable -s (sort) and then saving the column value and the
       record number for each sorted row. This index will be used automatically
	by funtools filtering of that column, provided the index file's modification date is later than that of the data file.

       The first required argument is the name of the FITS binary table to index. Please note that text files cannot be indexed at this time.  The
       second required argument is the column (key) name to index. While multiple keys can be specified in principle, the funtools index process-
       ing assume a single key and will not recognize files containing multiple keys.

       By default, the output index file name is [root]_[key].idx, where [root] is the root of the input file. Funtools looks for this specific
       file name when deciding whether to use an index for faster filtering. Therefore, the optional third argument (output file name) should not
       be used for funtools processing.

       For example, to create an index on column Y for a given FITS file, use:

	 funindex foo.fits Y

       This will generate an index named foo_y.idx, which will be used by funtools for filters involving the Y column.

SEE ALSO

       See funtools(7) for a list of Funtools help pages

version 1.4.2							  January 2, 2008						       funindex(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Substitute to GROUP BY function

Discussion started by: rinku11

2. Shell Programming and Scripting

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

Discussion started by: rajan_san

3. Shell Programming and Scripting

Awk-Group count of field

Discussion started by: tinivt

4. Shell Programming and Scripting

awk group by

Discussion started by: mutti