Shell Programming and Scripting

  CAR                DESIGN          COLOUR        SERVICE 
  MERZ              APPLE             RED              2 YEARS
                       ORANGE
                       GRAPE            
   
  VW                                      WHITE          0 YEAR
   
  AUDI               MANGO             BLUE              1 YEAR

MERZ , APPLE , ORANGE ,  GRAPE , RED , 2 YEARS
VW , WHITE , 0 YEAR
AUDI , MANGO , BLUE , 1 YEAR

awk '{print $1 ", " $2 ", " $3 ", " $4 " " $5 }' file.txt | grep -v "CAR"

#!/usr/bin/perl

undef $\;
open (FH,"<","/dir/cardetails");

while (<FH>) {
if ($. == 1 ) { next ; }
if (/^\s+$/) { next ; }
if (/^\s\s(\w+)\s+(\w+)\s+(\w+)\s+(.*)/) {
if ( defined ($f3) ) {
print " $f3,$f4 \n";
}
print "$1,$2,";
$f3=$3; $f4=$4;
}
else {
chomp;
print "$_,";
}
}
if ( defined ($f3) ) {
print "$f3,$f4 \n";
}
close(FH);

awk '/YEAR/{$1=$1;print}' OFS=", " file |sed 's/\(.*\),\(.*\)/\1\2/'

MERZ, APPLE, RED, 2 YEARS
VW, WHITE, 0 YEAR
AUDI, GREEN, BLUE, 1 YEAR