how to filter column from a text file

Question

Hyo Wan Park 2018-9-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/421199-how-to-filter-column-from-a-text-file

评论： Stephen23 2018-9-28

采纳的回答： Stephen23

在 MATLAB Online 中打开

I combined two text files into one file.

and then i have to filter column.

For example,

0  123  0.234  0.1234  0.1234  0.123
1  123  0.234  0.1234  0.1234  0.123
1  123  0.234  0.1234  0.1234  0.123
  5  560  0.123  0.2345  0.5412  0.899
  8  560  0.123  0.2345  0.5412  0.899
  8  560  0.123  0.2345  0.5412  0.899

I need two columns skipped and fprintf again in the text file.

Like this,

 0.234  0.1234  0.1234  0.123
 0.234  0.1234  0.1234  0.123
 0.234  0.1234  0.1234  0.123
   0.123  0.2345  0.5412  0.899
   0.123  0.2345  0.5412  0.899
   0.123  0.2345  0.5412  0.899

how can I do that?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Stephen23 2018-9-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/421199-how-to-filter-column-from-a-text-file#answer_338853

编辑：Stephen23 2018-9-28

在 MATLAB Online 中打开

fmt = '%-6d  %.3f  %.4f  %.4f  %.3f\n';
mat = dlmread('test_old.txt');
[fid,msg] = fopen('test_new.txt','wt');
assert(fid>=3,msg)
fprintf(fid,fmt,mat(:,[1,4:end]).')
fclose(fid);

Or simply use Notepad++: select those columns using shift+alt, then press delete.

2 个评论
显示无隐藏无

Hyo Wan Park 2018-9-28

Thanks a lot!!!! it's so perfect answers to me.

Stephen23 2018-9-28

Another option would be to read the file using textscan, with string format specifiers. Then you could retain exactly the same character data that the first file contains.

请先登录，再进行评论。