Hi everyone,
I have a csv file which has data with different heading and column names as below.
Static Data Ingested
,,,,,,,,,,,,Known Explained Rejections
Column_1,column_2,Column_3,Column_4,,Column_6,Column_7,,% Column_8,,Column_9 ,Column_10 ,
viv,Public_456,08/28/2013,1234566,,08/31/2013,5896325,,0.00,,0,0
SDS,Public_ddd,08/28/2013,589652,,08/31/2013,2365896,,0.00,,0,0
Static Data extracted
Column_1,Column_2,Column_3,Column_4,,Column_6
rms,k2c,08/28/2013,1234566,08/31/2013,5896325,0.00,0,0
SDS,k3c,08/28/2013,589652,08/31/2013,2365896,0.00,0,0
In the first one there are 10 columnwhere columns are separated by either , or ,,
Static Data Ingested is the heading for first data.
Similarily for second Static Data extracted is the heading and has 6 columns all separated by ,.
i want to write a shell script to extract 1 and 6-10 columns from first one and 1 and 4-6 from second.
Please help.