I have many csv files. The original design was supposed to have five columns.
I just found out that the middle column of the csv file has a string with arbitrary number of commas in it and it is not quoted properly. This leads to rows with arbitrary number of columns.
How do I get just the first two and last two columns of these csv files?
Since the number of commas can change from row to row I need a way to specify first two and last two columns.