reading selected columns of multiple files and storing the data

9 次查看（过去 30 天）

Sumera Yamin 2018-6-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/403878-reading-selected-columns-of-multiple-files-and-storing-the-data

评论： Sumera Yamin 2018-6-6

file_ex.txt

Hi, I have a simple problem but as a beginner stuck on it. I want to read 10 files in matlab with 3 columns in each file. I want to read last two columns of each file, store the values of each column individually in a column vector (to be used later on in code). In this way i will have 10 column vectors. What would be the best way to do it. Any help will be highly appreciated. My idea is to read one file and store the column and then apply for loop. But reading one file, as shown in my code below gives the output as reading data of all three columns and printing them in the form of an array.

fid = fopen('C:\Users.......file_ex.txt','rt');   % .....  shows path for the file location
indata = textscan(fid, '%f', 'HeaderLines',0);
fclose(fid);
yourdata = indata{1}

the output is as shown below.

the original file is as attached. I will be grateful if anyone could help.

5 个评论
显示 3更早的评论隐藏 3更早的评论

jonas 2018-6-4

在 MATLAB Online 中打开

use

readtable('file_ex.txt')

instead of textscan

Sumera Yamin 2018-6-4

i see now. Somehow original file became corrupt. sorry for that mistake. I have attached the file again. hope its ok now.

请先登录，再进行评论。

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

回答（1 个）

Walter Roberson 2018-6-4

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/403878-reading-selected-columns-of-multiple-files-and-storing-the-data#answer_323103

在 MATLAB Online 中打开

yourdata = cell2mat( textscan(fid, '%*f%f%f', 'CollectOutput', 1) );

"store the values of each column individually in a column vector (to be used later on in code). In this way i will have 10 column vectors"

That part is not clear. In the case of the sample file which contains 8 rows, do you want all of column 2 followed by all of column 3? Or do you want two different outputs, one for each column?