Implementing Listagg like function in shell Post: 302976340

Sponsored Content

Top Forums Shell Programming and Scripting Implementing Listagg like function in shell Post 302976340 by RudiC on Tuesday 28th of June 2016 10:19:08 AM

06-28-2016

Registered User

Next version: duplicate field contents removed; multiple OFS reduced to single:

Code:

awk '
NR == 1         {KN = split (KEYCOL, KC, ",")
                 AN = split (AGGCOL, AC, ",")
                }
                {KEY = ""
                 for (i=1; i<=KN; i++)  {KEY = KEY $KC[i] OFS
                                         $KC[i] = ""
                                        }
                 for (i=1; i<=AN; i++)  {if (F[KEY,i] !~ "(^|,)" $AC[i] "(,|$)")        {F[KEY,i] = F[KEY,i] DL[KEY,i] $AC[i]
                                                                                         DL[KEY,i] = ","
                                                                                        }
                                         $AC[i] = "\001" i
                                        }
                 LINE[KEY] = $0
                }
END             {for (l in LINE)        {for (i=1; i<=AN; i++)  sub ("\001" i, F[l,i], LINE[l])
                                         OP = sprintf ("%s%s%s", l, OFS, LINE[l])
                                         gsub (OFS OFS "*", OFS, OP)
                                         print OP
                                        }
                }
' OFS="\t" KEYCOL="1" AGGCOL="2,4" file
B00000	1	...	abc
B00001	1,2,3	...	abc,def,ghi,jkl,ybc,xab
B00002	1,2	...	abc,def
B00003	1	...	xyz

(tested with an extended input file)

This User Gave Thanks to RudiC For This Post:

RudiC

View Public Profile for RudiC

Find all posts by RudiC

10 More Discussions You Might Find Interesting

1. Programming

Implementing a shell

I'm implementing a shell in C that supports piping, output redirection, and background processing, and a few other commands. I was wondering how I'd go about implementing the output redirection. So, I'd open a file and I'd fork and execute the command. But how would I get stdout into the file? Any...

2. Programming

need help in implementing simple interactive shell in C

hello all, i hv attached herewith my program to implement a simple interactive shell in C. no matter hw hard I try, I keep getting some errors. i need help - urgently !! proj1test7.c: In function `parseCommand': proj1test7.c:102: warning: assignment makes pointer from integer without a cast...

3. Programming

Implementing a shell in C

Hi, I am implementing a shell in C, with the following problem... Suppose the shell is invoked from the command line as >> myshell < test.in > test.out 2>&1 I have to execute the commands in test.in and redirect them to test.out How does one detect in the main function that the shell...

4. Homework & Coursework Questions

implementing mkdir, chdir, mv, pwd inside a shell !

1. The problem statement, all variables and given/known data: need to implement mkdir, chdir, mv, pwd given a shell.cpp directory.cpp and some other files this shell missing these commands, and i need to implement them inside the shell 2. Relevant commands, code, scripts,...

5. Shell Programming and Scripting

Implementing Queue Using Shell scripts

HI I want to implement a control mechanism using Shell scripts .The intention is to have controlled number of jobs running in parallel External process will kickstart 40 jobs in parallel .All the 40 jobs will call the same generic script with different parameter values .But at a...

6. Programming

Problem with implementing the times() function in C (struct tms times return zero/negative values)

Hello, i'm trying to implement the times() function and i'm programming in C. I'm using the "struct tms" structure which consists of the fields: The tms_utime structure member is the CPU time charged for the execution of user instructions of the calling process. The tms_stime structure...

7. Programming

Implementing function outside struct

I have this code where I have declared a struct with some functions. Trying to write the function implementation outside the struct declaration and do not know how to proceed. #ifndef ParseEl_hh #define ParseEl_hh #include <iostream> #include <fstream> #include "DynBaseObj.hh"...

8. Shell Programming and Scripting

Need help implementing a timout in my Shell Script for RHEL6

Hey Guys, My problem: I have a script that will be querying the database every minute to see if it gets a response, the response its querying for is "UP" in a table i made called dbup in the database. Now, I am trying to add the component to implement a timeout if the script does not get a...

9. Shell Programming and Scripting

Implementing linked list in shell scripting

Hello Experts, Is it possible to implement linked list in shell scripting? is yes then how can we do it? Any working example is highly appreciated. Thanks in advance.

10. UNIX for Beginners Questions & Answers

DB2 Query modification to remove duplicate values using LISTAGG function

I am using DB2 v9 and trying to get country values in comma seperated format using below query SELECT distinct LISTAGG(COUNTRIES, ',') WITHIN GROUP(ORDER BY EMPLOYEE) FROM LOCATION ; Output Achieved MEXICO,UNITED STATES,INDIA,JAPAN,UNITED KINGDOM,MEXICO,UNITED STATES The table...

LEARN ABOUT HPUX

split

split(1)						      General Commands Manual							  split(1)

NAME

       split - split a file into pieces

SYNOPSIS

       line_count] suffix_length] [file [name]]

       nsuffix_length] [file [name]]

   Obsolescent
       n] [file [name]]

DESCRIPTION

       reads  file  and  writes  it  in  pieces  (default  1000 lines) onto a set of output files.  The name of the first output file is name with
       appended, and so on lexicographically, up to (only ASCII letters are used, a maximum of 676 files).  If no output name  is  given,  is  the
       default.

       If no input file is given, or if is given instead, the standard input file is used.

   Options
       recognizes the following command-line options and arguments:

	      The input file is split into pieces
			     line_count lines in size.

	      suffix_length  letters  are  used  to  form the suffix of the output filenames.  This option allows creation of more than 676 output
			     files.  The output file names created cannot exceed the maximum file name length allowed in the directory	containing
			     the files.

	      The input file is split into pieces
			     n bytes in size.

	      The input file is split into pieces
			     n x 1024 bytes in size.  No space separates the n from the

	      The input file is split into pieces
			     n x 1048576 bytes in size.  No space separates the n from the

	      The input file is split into pieces
			     n lines in size.  This option is obsolescent and is equivalent to using the option.

EXTERNAL INFLUENCES

   Environment Variables
       determines the locale for the interpretation of text as single- and/or multi-byte characters.

       determines the language in which messages are displayed.

       If  or  is  not specified in the environment or is set to the empty string, the value of is used as a default for each unspecified or empty
       variable.  If is not specified or is set to the empty string, a default of "C" (see lang(5)) is used instead of

       If any internationalization variable contains an invalid setting, behaves as if all internationalization variables are  set  to	"C".   See
       environ(5).

   International Code Set Support
       Single- and multi-byte character code sets are supported.

SEE ALSO

       csplit(1).

STANDARDS CONFORMANCE

																	  split(1)

10 More Discussions You Might Find Interesting

1. Programming

Implementing a shell

Discussion started by: ununium

2. Programming

need help in implementing simple interactive shell in C

Discussion started by: nix1209

3. Programming

Implementing a shell in C

Discussion started by: jacques83

4. Homework & Coursework Questions

implementing mkdir, chdir, mv, pwd inside a shell !

Discussion started by: evantheking