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