I have a large csv file which looks like this:
"Ion N","Mass","Charge","X","Y","Z","Azm","Elv","KE"3849094,0.00054858,-1,66.5216,-51,-3.8,-180,88.7,181603849095,0.00054858,-1,27.3925,30.3532,-4.07076,-177.1,41.5494,17697.23849096,0.00054858,-1,66.5216,-51,-3.7,-180,88.7,181603849097,0.00054858,-1,26.6277,31.0039,-3.91402,-177.096,40.8293,17699.43849098,0.00054858,-1,66.5216,-51,-3.6,-180,88.7,181603849099,0.00054858,-1,4.125,44.9887,-2.47517,-176.363,25.715,17711.1
To create and array with each second row I use the following command:
data(2:2:end,:) = []
My output file then looks like this:
"Ion N","Mass","Charge","X","Y","Z","Azm","Elv","KE" 3849095,0.00054858,-1,27.3925,30.3532,-4.07076,-177.1,41.5494,17697.2 3849097,0.00054858,-1,26.6277,31.0039,-3.91402,-177.096,40.8293,17699.4 3849099,0.00054858,-1,4.125,44.9887,-2.47517,-176.363,25.715,17711.1
However, I wish to keep the first row and delete the second one and keep the third row and so on but the following command doesn't seem to work.
data(1:1:end, :) = []
My desired output file should look like this:
"Ion N","Mass","Charge","X","Y","Z","Azm","Elv","KE"3849094,0.00054858,-1,66.5216,-51,-3.8,-180,88.7,181603849096,0.00054858,-1,66.5216,-51,-3.7,-180,88.7,181603849098,0.00054858,-1,66.5216,-51,-3.6,-180,88.7,18160
Could anyone advise on how I can implement this?
Best Answer