I would like to solve the problem below using AWK.
If any other solutions are possible using languages such as sed or Perl, that would also be much appreciated.
Below is the input:
U,N,UNIX,000,A,5 N,P,SHELL,111,B,6 I,M,UNIX,222,C,7 X,Y,BASH,333,D,8 P,R,SCRIPT,444,E,9
I want the output as below:
U,N,,,A,5 N,P,,,B,6 I,M,,,C,7 X,Y,,,D,8 P,R,,,E,9
Please also note that: the total number of fields per line is unknown to me. I only know that fields 3 and 4 are to be blanked.