Hi,
my sql query return below value for " $SQL_OPN_AMT "
CUSTCODE OH OHOPNAMT_GL OHREFNUM -------------------------------- -- ----------- ------------------------------ OHENTDATE FCC --------- --- 1.1072256 IN 74.85 000072061
0 01-MAY-13 MVR 1.1072256 IN 751.72 0000744751 01-JUN-13 MVR 1.1072256 IN 382.19 0000790408 01-AUG-13 MVR CUSTCODE OH OHOPNAMT_GL OHREFNUM -----------------------------
--- -- ----------- ------------------------------ OHENTDATE FCC --------- --- 1.1072256 IN 589.8 0000768242 01-JUL-13 MVR 1.1072256 IN 216 0000810616 01-SEP-13 MVR
CUSTCODE OH OHOPNAMT_GL OHREFNUM -------------------------------- -- ----------- ------------------------------ OHENTDATE FCC --------- --- 2.38.00.00.100010 IN 948.32
0000856580 01-NOV-13 MVR
I am using below code to display in tabular form.
echo $SQL_OPN_AMT | /usr/xpg4/bin/awk -F' ' '{for(i=13;i<=NF;i++){printf("%s%s",$i,i%6?" ":"\n")}}' >> cust_amt_dtls.tmp
but my out put is showing as below.
1.1072256,DD,74.85,0000720610,01-MAY-13,MVR
1.1072256,DD,751.72,0000744751,01-JUN-13,MVR
1.1072256,DD,589.8,0000768242,01-JUL-13,MVR
1.1072256,DD,382.19,0000790408,01-AUG-13,MVR
1.1072256,DD,216,0000810616,01-SEP-13,MVR
2.38.00.00.100010,DD,948.32,0000856580,01-NOV-13,MVR
-----------,------------------------------,,DDC,---------,---
CUSTCODE,OH,,OHREFNUM,--------------------------------,--
I want to remove the extra lines/characters coming along with the tabular output.
i.e my output should be
1.1072256,DD,74.85,0000720610,01-MAY-13,MVR
1.1072256,DD,751.72,0000744751,01-JUN-13,MVR
1.1072256,DD,589.8,0000768242,01-JUL-13,MVR
1.1072256,DD,382.19,0000790408,01-AUG-13,MVR
1.1072256,DD,216,0000810616,01-SEP-13,MVR
2.38.00.00.100010,DD,948.32,0000856580,01-NOV-13,MVR
Thanks
Bhavish