Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Output Formatting
Top Forums Shell Programming and Scripting Output Formatting Post 302519776 by mooey1232003 on Thursday 5th of May 2011 04:13:27 AM
Old 05-05-2011
Output Formatting
Hi Guys

I need help removing some lines from output i am receiving from a shell script.
Here is the output:

Image
I am trying to remove the output that i have circled.

Code:
. ${EDW}/extracts/bin/extracts_setup2.sh
. ${EDW}/extracts/extracts.conf

date_f=`date +%Y%m%d` 
DATADIR=/extracts/
OUTFILE=article.$date_f   ; rm -f $OUTFILE
OUTFILEgo=article$date_f ; rm -f $OUTFILEgo

isql -U${USER} -P${PASSWD} -S${SERVER} > ${DATADIR}${OUTFILE} << EOF
go
select rtrim(departmentDescr)+ ','+ rtrim(categoryDescr)+ ','+ rtrim(brandDescr)+ ','+ 
convert(varchar,barcode)+ ','+ convert(varchar,uot)+ ','+ convert(varchar,skuId)+ ','+ rtrim(uotDescr)+ ','+ 
rtrim(convert(varchar,convert(int, uomQty))||uomDescr)
from DBA.DimProduct, DBA.BarcodeUot
where uot = unitOfTradeId
and uotDescr not like 'DISCONTINUED%'
and divisionDescr in ('FOODS', 'HARDS','SOFTS','PERISH')
order by departmentDescr, categoryDescr, skuId
go
EOF

cd ${DATADIR}

echo 'Department Description,Category Description,Brand Description,Barcode,Unit Of Trade,Sku Id,Unit Of Trade Description,Unit Of Measurement Qty' >>$OUTFILEgo


cat $OUTFILE |sed '/^$/d;/affected/d;s/  *$//' >> $OUTFILEgo


sed '
s/|$//g
s/"//g ' $OUTFILEgo > $OUTFILE
mv $OUTFILE $OUTFILEgo
gzip -9 $OUTFILEgo


cat $OUTFILE |grep -v 'rows affected' >> $OUTFILEgo


rm -f $OUTFILE
rm -f $OUTFILEgo

Thanks Smilie
 

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

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

9. AIX

Help Formatting Output

I am using FORTRAN 90 on AIX 5.3 and need to output my data to a tab-delimited file. It must have actual tabs, and I cannot figure out a way to make it work. The resulting file will be imported into another application (quickbooks) as an .iif file....for some reason, it needs the tabs; spaces do... (2 Replies)
Discussion started by: KathyB148
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 DEBIAN

lpsrewr

LPSREWR(1)							   User Commands							LPSREWR(1)

NAME

       lpsrewr - rewrite data expressions in an LPS

SYNOPSIS

       lpsrewr [OPTION]... [INFILE [OUTFILE]]

DESCRIPTION

       Rewrite	data expressions of the LPS in INFILE and save the result to OUTFILE.If OUTFILE is not present, standard output is used. If INFILE
       is not present,standard input is used

OPTIONS

       OPTION can be any of the following:

       -rNAME, --rewriter=NAME
	      use rewrite strategy NAME:
		'jitty' for jitty rewriting (default),
		'jittyc' for compiled jitty rewriting,
		'jittyp' for jitty rewriting with prover

       --timings[=FILE]
	      append timing measurements to FILE. Measurements are written to standard error if no FILE is provided

       Standard options:

       -q, --quiet
	      do not display warning messages

       -v, --verbose
	      display short intermediate messages

       -d, --debug
	      display detailed intermediate messages

       --log-level=LEVEL
	      display intermediate messages up to and including level

       -h, --help
	      display help information

       --version
	      display version information

AUTHOR

       Written by Wieger Wesselink and Muck van Weerdenburg.

REPORTING BUGS

       Report bugs at <http://www.mcrl2.org/issuetracker>.

COPYRIGHT

       Copyright (C) 2012 Technische Universiteit Eindhoven.
       This   is   free   software.    You   may   redistribute   copies   of	it   under   the   terms   of	the   Boost    Software    License
       <http://www.boost.org/LICENSE_1_0.txt>.	There is NO WARRANTY, to the extent permitted by law.

SEE ALSO

       See also the manual at <http://www.mcrl2.org/mcrl2/wiki/index.php/User_manual/lpsrewr>.

lpsrewr mCRL2 toolset 201202.0 (Release)			    April 2012								LPSREWR(1)
All times are GMT -4. The time now is 01:07 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy