Shell Programming and Scripting

$ cat test.in
/home/username/ABC1/rstfiles4.log
/home/username/ABC4/rstfiles2.log
/home/username/EDC7/rstfiles23.log
/home/username/EDC6/rstfiles55.log
/home/username/rstfiles15.log

$ sed 's:^/home/username/::' test.in |
sed 's:^\(...\).*/:\1,:' |
sed 's:\,\(...\)[^.]*:,\1*:' |
sed 's:^\([^,][^,][^,]\)[^,]*\.:,\1.:' | uniq
ABC,rst*.log
EDC,rst*.log
,rst.log

sed "s:^${mypath}/::" test.in |
sed 's:^\(...\).*/:\1,:' |
sed 's:\,\(...\)[^.]*:,\1*:' |
sed 's:^\([^,][^,][^,]\)[^,]*\.:,\1.:' | uniq

for i in `cat filename`
do
   BASE=`basename $i`
   DIR=`dirname $i | xargs basename`
   echo $DIR "," $BASE
done