format csv file using shell script

UNIX for Advanced & Expert Users
1

i have a report.csv file from oracle datavase
In that file data is like this with report heading and date

SALES DAILY REPORT
DATE: 06-26-2007
REPORT NAME: SALES DATA

AA.BB.CCCC.DDDD,BBBBB,06-26-2007,0,BEGIN,END
ZZ.VV.DDDD.XXXXXXX,MMMMMM,06-25-2007,18,BEGIN,END
CC.XX.VVV.QQ,KKKKK,06-24-2007,END,BEGIN
fields are separated with ",".
i want to read this file create new file with new format.

i want
col1 WIDTH should increse 15 positions with spaces right side
col2 WIDTH should increse 10 positions with spaces right side
col3 WIDTH should increse 5 positions with spaces right side
col4 WIDTH should increse 7 positions with spaces right side
col5 WIDTH should increse 7 positions with spaces right side
col6 WIDTH should increse 6 positions with spaces right side
BUT HEADING OF THE REPORT SHOULD NOT BE CHANGED.

I WANT NEW OUTPUT FILE SHOULD BE LIKE THIS

SALES DAILY REPORT
DATE: 06-26-2007 
REPORT NAME: SALES DATA

AA.BB.CCCC.DDDD          ,BBBBB     ,06-26-2007   ,0   ,BEGIN   ,END
ZZ.VV.DDDD.XXXXXXX        ,MMMMMM     ,06-25-2007,18  ,BEGIN   ,END
CC.XX.VVV.QQ      ,KKKKK    ,06-24-2007       ,15     ,END    ,BEGIN

Thanks for your help
i need answer desparately.
N.

2

raosurya,
now that we all know your 'needs' and your previous postings on a very similar subject, what are you desperate "deeds" to find a solution given all of the above?
Are you looking for help or are you leaching for a solution to a similar previously posted question?
Show the 'effort' and you might get a 'helping hand'.

3

No. absolutely NOT. some body gave me answer for this question which is not working. i posted reply in other post. but, NO body replied to me last week.thats why i asked the question again. I am sorry that. still i did n't get the answer yet. pl see code bellow. when i put this code the i am getting empty file.but, i must get the results.file should never be empty.

this is code replied to me:

awk 'BEGIN{
FS=","
print "<HTML><BODY><TABLE>"
}
{
printf "<TR>"
for(i=1;i<=NF;i++)
printf "<TD>%s</TD>", $i
print "</TR>"
}
END{
print "</TABLE></BODY></HTML>"
}
'Report.csv > Report11.xls

i understand every body's help. I am looking for answer.
i appreciate that.pl help me.
thx,N

4

You've been helped with more than 1 possible solutions. If you're not seeing the desired result do show the 'effort' explaining what you've done to understand the solutions and to improve on it. A simple 'it does not work' will not help you getting somebody's attention.

Also pls read the Rules of these forums paying attention to #4:
(4) Do not 'bump up' questions if they are not answered promptly. No duplicate or cross-posting and do not report a post or send a private message where your goal is to get an answer more quickly.

I'm closing the 'duplicate' thread.