print "count,pub,prodline,group,sector,date,source" > $fname

cat sp_log.summary.$firstday-$lastday.ProdlineSector | sed "s/^ *//g;s/ *$//g" >sp_log.summary.$firstday-$lastday

cat sp_log.summary.$firstday-$lastday | sed "s/$/ $lastyy-$lastmm cache/;s/ /,/g" >> $fname

cat $fname | sed "s/NULL//g" >$fname.new


THIS is the part of a shell script which creates a .CSV file.

Now for the data under pub field, i want to inset a ' in front of the data getting inserted.

Can someone please help??