Shell Programming and Scripting

I have a problem about one file. my source file as following:
123, accounting, university street, 23456
124, financing, center street, b suit, 23457
125, information, college street, 23458
above file, 'center street, b suit' should be one field, my file contains more than 50 columns.
target should be
123, accounting, university street, 23456
124, financing, center street b suit, 23457
125, information, college street, 23458

eg. 126,,shepperd street, 203#, 23459

Originally Posted by Scrutinizer

Try this:

Code:

awk -F, 'NF==5{sub($3","$4,$3$4)}1' infile