Shell Programming and Scripting

hi
I unload the table results from oracle to csv file foramt.
i need increse the width of each column using unix commands
could you pl tell me how to increase the width of each column to spefic width uisng sed unix command or na other unix commands

i have file name called report.csv
inside this file
here is the contents
here are record of csv file
pl tell me how to increase the column width from this.
aaaaaaaaaaa,bbbb,cccccccccc,dddd,eeeeeeeeeeee
bbbbb,ccccc,zzzzzzzzzzz,vvvvvvvvv,mmmm

pl tell me what is script for sovle this problem.

thx,N.

Raosurya,
Your requirement:
leaves us with questions:
- Which columns do you want to increase.
- How many positions do you want to increase.
- What justification do you want:
. Left.
. Right.
. Center.
- What filling character do you want.

Code:

awk -F"," '{printf "%-20s %-20s %-20s %-20s %-20s\n",$1,$2,$3,$4,$5}' <file-name>

Thanks for your quick reply.
i am sorry about that.
i want to incrase all the columns and all the records in that file
the result should be in new file.
i want increase right of each column around 15 positions on the first column,
5 postions on 2nd column, 4 positions on 3rd column, 4th and 5th sould be 2 postions.

the result should be stored in new file



the filling character will be space.



pl reply fast. thanks,N.

Raosurya,
If you have a csv file, what is the need for padding the fields?
Is this a homework?

can you paste some sample from your file and the way you want it to be formatted?

NO.
what is my problem is i sent this CSV FILE to excel spread sheet.
when open the csv file, i could not see whole column width. it showing excel default column width. so, i cannot see whole column. i need to manually darg he column to see column result. so, i want to increase the column width before sening to e-mail attachment.
that is my problem.

thx for your help. pl write the script

thx.N.