Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: formatting the output
Top Forums Shell Programming and Scripting formatting the output Post 302223945 by Annihilannic on Monday 11th of August 2008 10:03:05 PM
Old 08-11-2008
Try this:

Code:
echo "JObID,Tablename,Instancename,output rows x,affected rows x,applied rows x,rejected rows x, output rows y,affected rows y,applied rows y,rejected rows y"
awk '
        /^Summary/ { testrun=tolower($9) }
        /^Job/ {
                gsub("[][~(),]","") # strip out the unwanted characters
                jobid=$3
                table=$5
                instance=$8
                rowindex[jobid SUBSEP table SUBSEP instance]
                output  [jobid SUBSEP table SUBSEP instance SUBSEP testrun]=$11
                affected[jobid SUBSEP table SUBSEP instance SUBSEP testrun]=$14
                applied [jobid SUBSEP table SUBSEP instance SUBSEP testrun]=$17
                rejected[jobid SUBSEP table SUBSEP instance SUBSEP testrun]=$20
        }
        END {
                OFS=","
                for (i in rowindex) {
                        split(i,a,SUBSEP)
                        jobid=a[1]
                        table=a[2]
                        instance=a[3]
                        print jobid,table,instance,
                                output  [jobid SUBSEP table SUBSEP instance SUBSEP "x"],
                                affected[jobid SUBSEP table SUBSEP instance SUBSEP "x"],
                                applied [jobid SUBSEP table SUBSEP instance SUBSEP "x"],
                                rejected[jobid SUBSEP table SUBSEP instance SUBSEP "x"],
                                output  [jobid SUBSEP table SUBSEP instance SUBSEP "y"],
                                affected[jobid SUBSEP table SUBSEP instance SUBSEP "y"],
                                applied [jobid SUBSEP table SUBSEP instance SUBSEP "y"],
                                rejected[jobid SUBSEP table SUBSEP instance SUBSEP "y"]
                }
        }
' inputfile | sort

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Formatting the output

Hi all, Have the following code(1) producing the results(2 & 3). Would like to know if there is a way to format the two reports created in a similar fashion. IE - The first is formatted nicely as a result of the echo "$xmpbdate $xavgs" >> $xmpbrpt However when I attempt to do the same on... (7 Replies)
Discussion started by: Cameron
7 Replies

2. Shell Programming and Scripting

formatting output

Hi need some advice.. #grep -i hostname test.csv (gives the below output) HOSTNAME,name,host_test,,,,,,,, Now I need to format the above output as below. HOSTNAME: name=host_test Any easy way of doing this using awk or sed or printf? (4 Replies)
Discussion started by: balaji_prk
4 Replies

3. Shell Programming and Scripting

Formatting Output

Hi I tried running the below awk 'BEGIN { printf ("%s %-51s %s %-7s %s",$var1,$var2,$var3,$var4,$var5)}' from the command prompt and it is not working. Getting the error awk: Field $() is not correct. The source line number is 1. Actually my requirement is to form a string based on... (6 Replies)
Discussion started by: dhanamurthy
6 Replies

4. Shell Programming and Scripting

more help with formatting ls output...

Ok, for a fun project, my goal is to replicate the style of "catalog" on an old apple ] *A 002 SOMEAPPLESOFTFILE B 004 SOMEFILE T 006 SOMETEXT I 002 SOMEINTEGERFILE The first character is either " " or "*" depending on if the file is locked or not. Next is the filetype, so in... (1 Reply)
Discussion started by: patrick99e99
1 Replies

5. Shell Programming and Scripting

Formatting ls output

I am using find and ls to search for "warez" files on my server. find /home/ -regex ".*\.\(avi\|mp3\|mpeg\|mpg\|iso\)" -print0 | xargs -0 ls -oh This command produces this: -rw-r--r-- 1 1000 3.2M Feb 18 2009 /home/user/public_html/lupus.mp3 I want to only get this 3.2M... (4 Replies)
Discussion started by: bonrad
4 Replies

6. Shell Programming and Scripting

formatting output

Sorry for being a n00b, but I'm having a lot more trouble than I should with formatting the output to the program I finally completed. I'm basically looking for the linux equivalent to setw( ) from c++ so that I can print things in columns like this (but without the underlines lol): MISSPELLED: ... (4 Replies)
Discussion started by: aikaterinimak
4 Replies

7. Shell Programming and Scripting

Formatting of output

Hi Experts, I have to create a report for certain audit and my output looks as follows I m trying to format my output to look like Any inputs would be highly appreciated Thanks Syed (5 Replies)
Discussion started by: maverick_here
5 Replies

8. Shell Programming and Scripting

Output Formatting

Hi Guys I need help removing some lines from output i am receiving from a shell script. Here is the output: http://i52.tinypic.com/10z0fut.png I am trying to remove the output that i have circled. . ${EDW}/extracts/bin/extracts_setup2.sh . ${EDW}/extracts/extracts.conf ... (7 Replies)
Discussion started by: mooey1232003
7 Replies

9. Shell Programming and Scripting

Formatting the output

Hi, I have a file which contents entries in this form. Only in /data4/temp abc.000001 Only in /data4/temp abc.000003 Only in /data4/temp abc.000012 Only in /data4/temp abc.000120 Only in /data4/temp abc.000133 Only in /data4/temp abc.001444 i want to read line by line and format... (2 Replies)
Discussion started by: arijitsaha
2 Replies

10. Shell Programming and Scripting

Formatting the Output

Hi, I am trying to use printf command and format certain output in a specific format as under: While the left side (upto |) of the above format is part of a fixed header function, the right side is where i am expecting data to be printed. However, as seen, Row1 value is reflecting on last... (5 Replies)
Discussion started by: EmbedUX
5 Replies

LEARN ABOUT PHP

ingres_num_rows

INGRES_NUM_ROWS(3)							 1							INGRES_NUM_ROWS(3)

ingres_num_rows - Get the number of rows affected or returned by a query

SYNOPSIS

       int ingres_num_rows (resource  $result)

DESCRIPTION

	This  function	primarily  is  meant to get the number of rows modified in the database. However, it can be used to retrieve the number of
       rows to fetch for a SELECT statement.

       Note

	       If scrollable cursors are disabled and this function is	called	before	using  ingres_fetch_array(3),  ingres_fetch_object(3),	or
	      ingres_fetch_row(3), the server will delete the result's data and the script will be unable to get them.

	       Instead, you should retrieve the result's data using one of these fetch functions in a loop until it returns FALSE, indicating that
	      no more results are available.

PARAMETERS

	      o $result
		- The result identifier for a query

RETURN VALUES

	For delete, insert, or update queries, ingres_num_rows(3)  returns  the  number  of  rows  affected  by  the  query.  For  other  queries,
       ingres_num_rows(3) returns the number of rows in the query's result.

SEE ALSO

       ingres_query(3), ingres_fetch_array(3), ingres_fetch_assoc(3), ingres_fetch_object(3), ingres_fetch_row(3).

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