UNIX for Beginners Questions & Answers

AAA_POC_DB.TAB1
AAA_POC_DB.TAB2
AAA_POC_DB.TAB3
AAA_POC_DB.TAB4
BBB_POC_DB.TAB1
BBB_POC_DB.TAB2
CCC_POC_DB.TAB6

'AAA_POC_DB','TAB1','TAB2','TAB3','TAB4'
'BBB_POC_DB','TAB1','TAB2'
'CCC_POC_DB','TAB6'

awk -F"." -vs1="'" 'FNR==NR{A[$1]=A[$1]?A[$1] OFS s1 $NF s1:s1 $NF s1;next} A[$1]{print s1 $1 s1 OFS A[$1];delete A[$1]}' OFS=,   Input_file  Input_file

'AAA_POC_DB','TAB1','TAB2','TAB3','TAB4'
'BBB_POC_DB','TAB1','TAB2'
'CCC_POC_DB','TAB6'

awk -F. -vFMT="'%s'" '$1 != LAST {printf QRS FMT, $1; QRS = ORS; LAST = $1} {printf "," FMT, $2} END {printf ORS}' file
'AAA_POC_DB','TAB1','TAB2','TAB3','TAB4'
'BBB_POC_DB','TAB1','TAB2'
'CCC_POC_DB','TAB6'

while IFS=. read a b;
do
if [ "$x" != "$a" ]; then 
x=$a
printf "\n'%s','%s'" "$x" "$b"
else 
printf ",'%s'" "$b"
fi
done < file

#!/bin/bash

while IFS=. read a b;
do
if [ "$x" == "$a" ]; then 
printf ",'%s'" "$b"
else 
x=$a
printf "'%s','%s'" "$x" "$b"
fi
done < file | sed -e 's/'"'"''"'"'/'"'"'\n'"'"'/g'

sed -e 's/'\'\''/'\''\
'\''/g'

x=""; while IFS=. read a b
do
  if [ "$x" != "$a" ]; then 
    printf "${x:+\n}'%s','%s'" "$a" "$b"
    x=$a
  else 
    printf ",'%s'" "$b"
  fi
done < file