import *.dat and delete space at last column

Hi all, my problem is: I want import *.txt (attach file) or *.dat to Matlab *.dat has seven columns and at in last column are numbers and sometimes text (No data) and I need delete this space so output will (Nodata). For export I use this:

 number=35;
 fid = fopen('zkusebni.txt', 'r' );
 h2  = textscan( fid, '%s%s%s%s%s%s%s',number,'CollectOutput', true );
 fclose(fid);
C2 = [h2{:}];
C2 = cat(1,h2{:});

When I export this data by my function I get one more row where is in first column is writen (Data) and other columns are empty. So my goal is: I want have same count row like previously without this parasit row (I think I have to change something in h2=textscan()). If is not my text clear look at comments I upload two *.mat what I have from import zkusebni.txt and what I want :) Thank you for your response.

[KSSV]

Not clear what you want to do with the last column?

[Eduard Sláma]

Thank you for your response. I have (have_it.mat) and I want (want_it.mat) :) File want_it.mat I get when I delete manually space in zkusebni.txt. Goal is import zkusebni.txt and get want_it.mat

[KSSV]

The text file data and want_it.mat looks same.....what you want to edit there?

[Eduard Sláma]

Yes this is my goal...but from my code I get have_it.mat. I will have want_it.mat only when I mananually delete space between No data. zkusebni.txt is only sample from my full file. Full file has 621580 rows so I cant delete space between No data manually everywhere :)

Answer 1

[AbhimanyuSingh]

Please find attached .m file this will help you to solve your problem

[Eduard Sláma]

Thank you very much !!!!