Shell Programming and Scripting

here is a data file.
-------------------------------------
KSH, CSH, BASH, PERL, PHP, SED, AWK
KSH, CSH, BASH, PERL, PHP,
BASH, PERL, PHP, SED, AWK
CSH, BASH, PERL, PHP, SED,
KSH, CSH, BASH, PERL, PHP, SED, AWK
-------------------------------------

My desired output is
------------------------------------------------
KSH:Y CSH:Y BASH:Y PERL:Y PHP:Y SED:Y AWK:Y
KSH:Y CSH:Y BASH:Y PERL:Y PHP:Y SED:N AWK:N
KSH:N CSH:N BASH:Y PERL:Y PHP:Y SED:Y AWK:Y
KSH:N CSH:Y BASH:Y PERL:Y PHP:Y SED:Y AWK:N
KSH:Y CSH:Y BASH:Y PERL:Y PHP:Y SED:Y AWK:Y
------------------------------------------------

Can someone help!!

Hm,
there's got to be a better way ...
(use nawk on Solaris)

Code:

awk 'BEGIN { FS = ", *" 
n = split("KSH, CSH, BASH, PERL, PHP, SED, AWK", _) }
{ for (j=1; j<=NF; j++) __[$j] 
  for (i=1; i<=n; i++) 
    $i = _[i] in __ ? _[i] ":Y" : _[i] ":N" 
  split("", __) # use delete __ if GNU Awk 
}1' input

But you should add Z-Shell, Python and Ruby

Another approach:

Code:

awk 'BEGIN{FS=", ";OFS=" "
n=split("KSH, CSH, BASH, PERL, PHP, SED, AWK",a,FS)}
{ 
for(i=1;i<=n;i++) {
  s=match($0,a[i])?a[i]":Y ":a[i]":N "
  printf("%s",s)
}
print ""
}' file

Regards