import *.dat and delete space at last column

2 次查看(过去 30 天)
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.
  4 个评论
KSSV
KSSV 2017-8-10
The text file data and want_it.mat looks same.....what you want to edit there?
Eduard Sláma
Eduard Sláma 2017-8-10
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 :)

请先登录,再进行评论。

采纳的回答

AbhimanyuSingh
AbhimanyuSingh 2017-8-10
Please find attached .m file this will help you to solve your problem

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Large Files and Big Data 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by