Shell Programming and Scripting

namep1,a
namep2,b
namec1,a/b

namep1,a
namep3,b
namec2,a/b

namep2,a
namep3,b
namec3,a/b

namep8,a
namep9,b
namec10,a/b

namep1,s1
namep3,s2
namec1,s4
namec3,s5
namec3,s6
namec3,s7
namec2,s12
namec3,s8
namec1,s9
namec1,s10
namec2,s11
namec2,s13
namec2,s14
namec1,s15

namep1,s1,a
namep2,absent,b
namec1,s4,a/b
namec1,s9,a/b
namec1,s10,a/b
namec1,s15,a/b

namep1,s1,a
namep3,s2,b
namec2,s11,a/b
namec2,s12,a/b
namec2,s13,a/b
namec2,s14,a/b

namep2,absent,a
namep3,s2,b
namec3,s5,a/b
namec3,s6,a/b
namec3,s7,a/b
namec3,s8,,a/b

namep8,absent,a
namep9,absent,b
namec10,absent,a/b

for f in *
do
awk -F, 'NR==FNR{a[$1]=$0; next} $1 in a { $1=a[$1]}1' Serials.csv $f > $f.out
done

BEGIN {	FS = OFS = ","
}
FNR == NR {
	n[$1,++nc[$1]] = $2
	next
}
FILENAME == "Serials.csv" {
	nextfile
}
FNR == 1 {
	if(of != "")
		close(of)
	of = FILENAME ".out"
}
{	if(!($1 in nc))
		print $1, "absent", $2 > of
	else {	print $1, n[$1, 1], $2 > of
		if(FNR == 3)
			for(i = 2; i <= nc[$1]; i++)
				print $1, n[$1, i], $2 > of
	}
}

awk -f Serials.awk Serials.csv *.csv

ls | grep '.csv$' | xargs awk -f Serials.awk Serials.csv

	nextfile

	next

namec3,s8,,a/b

namec3,s8,a/b