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

fbsql_affected_rows

FBSQL_AFFECTED_ROWS(3)							 1						    FBSQL_AFFECTED_ROWS(3)

fbsql_affected_rows - Get number of affected rows in previous FrontBase operation

SYNOPSIS

       int fbsql_affected_rows ([resource  $link_identifier])

DESCRIPTION

       fbsql_affected_rows(3) returns the number of rows affected by the last INSERT, UPDATE or DELETE query associated with $link_identifier.

       Note

	       If  you	are  using transactions, you need to call fbsql_affected_rows(3) after your INSERT, UPDATE, or DELETE query, not after the
	      commit.

	If the last query was a DELETE query with no WHERE clause, all of the records will have been deleted from the table but this function will
       return zero.

       Note

	       When using UPDATE, FrontBase will not update columns where the new value is the same as the old value. This creates the possibility
	      that fbsql_affected_rows(3) may not actually equal the number of rows matched, only the number of rows that were literally  affected
	      by the query.

PARAMETERS

	      o $
		link_identifier  -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
		function will try to find an open link to the FrontBase server and if no such link is found it	will  try  to  create  one  as	if
		fbsql_connect(3) was called with no arguments.

RETURN VALUES

	If the last query failed, this function will return -1.

SEE ALSO

       fbsql_num_rows(3).

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