Awk to Break lines to multiple lines.

Shell Programming and Scripting
1

Input File:

 
nawk -F "|" '{
        for(i=1;i<=NF;i++) {
     if (i == 2) 
         {gsub(",","#",$i);z=split($i,a,"[#]")}
     else if (i == 3) 
         {gsub(",","#",$i);z=split($i,b,"[#]")}
 }
     if(z > 0) for(i=1;i<=z;i++)
  print $1,a,"Test";
     if(w > 0) for(j=1;j<=w;j++)
         print $1,b[j],"Testing";
  z=0;w=0
    }' OFS="|"  awktest.txt

Required Output:

2 
$ awk -F[\|\,] '{ for(i=2;i<=NF;i++) print $1,(i<=6)?$i"|Test":$i"|Testing"}' OFS="|" awktest.txt
123456789|H03|Test
123456789|H01|Test
123456789|R06|Test
123456789|R05|Test
123456789|C06|Test
123456789|H03|Testing
123456789|H01|Testing
123456789|R06|Testing
123456789|R05|Testing
123456789|C06|Testing