Code:
$ cat x.csv
baseball,NULL,8798765,Most played,0,5,12367,NULL,NULL,98,67,Reason is not sufficient
baseball,NULL,8928192,Most played,0,4,76893,NULL,RAW,54,78,Reason is not sufficient
baseball,NULL,5678945,Most played,9,2,1,6,NULL,6789,123,Reason not conclueded
cricket,NOTNULL,125782,Usually played,NULL,NULL,NULL,NULL,123,67,Reason not conclueded
cricket,NOTNULL,678921,Usually played,NULL,NULL,NULL,NULL,563,NULL,Reason not defines
Expected output
===============
baseball,NULL,8798765,Most played,0,5,12367,NULL,NULL,98,67,Reason is not sufficient
,NULL,8928192,Most played,0,4,76893,NULL,RAW,54,78,Reason is not sufficient
,NULL,5678945,Most played,9,2,1,6,NULL,6789,123,Reason not conclueded
cricket,NOTNULL,125782,Usually played,NULL,NULL,NULL,NULL,123,67,Reason not conclueded
,NOTNULL,678921,Usually played,NULL,NULL,NULL,NULL,563,NULL,Reason not defines
but the output that is displayed is :-
$ nawk 'BEGIN{FS=","}!a[$1] {print;a[$1]++;next}{print FS$2FS$3FS$4FS$5FS$6FS$7FS$8FS$9FS$10FS$11FS12}' x.csv
baseball,NULL,8798765,Most played,0,5,12367,NULL,NULL,98,67,Reason is not sufficient
,NULL,8928192,Most played,0,4,76893,NULL,RAW,54,78
,NULL,5678945,Most played,9,2,1,6,NULL,6789,123
cricket,NOTNULL,125782,Usually played,NULL,NULL,NULL,NULL,123,67,Reason not conclueded
,NOTNULL,678921,Usually played,NULL,NULL,NULL,NULL,563,NULL,Reason not defines
The last column in row 2 and rown3 is getting deleted
