Output Formatting


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Output Formatting
# 1  
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
# 2  
Old 05-05-2011
Won't this work?

Code:
sed 's/-//g' file

regards,
Ahamed

---------- Post updated at 12:20 AM ---------- Previous update was at 12:17 AM ----------

To remove the blank lines also

Code:
sed 's/-//g' file | awk '$0!="" {print}'

regards,
Ahamed

---------- Post updated at 12:21 AM ---------- Previous update was at 12:20 AM ----------

Even better

Code:
awk '!/^-/{print}' file

Smilie

regards,
Ahamed
This User Gave Thanks to ahamed101 For This Post:
# 3  
Old 05-05-2011
another one
Code:
sed '/-/d' yourfile

---------- Post updated at 10:28 AM ---------- Previous update was at 10:26 AM ----------

If you just want remove line 2 and 3 :

Code:
sed '2,3d' yourfile

This User Gave Thanks to ctsgnb For This Post:
# 4  
Old 05-05-2011
---------- Post updated at 03:33 AM ---------- Previous update was at 03:33 AM ----------

Quote:
Originally Posted by ctsgnb
another one
Code:
sed '/-/d' yourfile

---------- Post updated at 10:28 AM ---------- Previous update was at 10:26 AM ----------

If you just want remove line 2 and 3 :

Code:
sed '2,3d' yourfile


Thanks ill try that.
# 5  
Old 05-05-2011
Code:
sed '/-/d;/rtrim/d' yourfile

This User Gave Thanks to ctsgnb For This Post:
# 6  
Old 05-05-2011
Quote:
Originally Posted by ctsgnb
Code:
sed '/-/d;/rtrim/d' yourfile

Thanks that worked perfectly.
1 question: I have a blank space before "3RD Party". I put the code below in but it removes all the blank spaces in the file whereas i was the leading spaces on each row removed so
" 3RD Party" becomes "3RD Party"
Code:
sed '/ /d' yourfile

# 7  
Old 05-05-2011
Code:
sed '/-/d;/rtrim/d;s/^  *//' yourfile

This User Gave Thanks to ctsgnb For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

10. 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
Login or Register to Ask a Question