Separating a colymn into two columns (.txt file)

3 次查看（过去 30 天）

显示更早的评论

Ivan Mich 2019-9-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/481913-separating-a-colymn-into-two-columns-txt-file

评论： David K. 2019-10-1

采纳的回答： David K.

Hello,

I would like to separate a column into two different columns from a .txt file in Matlab. I used these commands:

t=readtable('file.txt','Delimiter','\t','HeaderLines',1)

and the results of these commands are in the pictures. Finally, I mean that i would like to separate line 11 into two vertical columns.

Which command should I use?

采纳的回答

David K. 2019-9-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/481913-separating-a-colymn-into-two-columns-txt-file#answer_393327

编辑：David K. 2019-9-24

在 MATLAB Online 中打开

I would do it like this:

%t = your table;
dataCell = table2cell(t); % convert to cells
dataCell = dataCell(11:end); % remove unneccessary text
cellNums = cellfun(@str2num,dataCell,'UniformOutput',0); % apply str to num on all the data
output = cell2mat(cellNums); % convert to matrix with 2 columns

*Edit: fixed a few things

10 个评论
显示 8更早的评论隐藏 8更早的评论

Ivan Mich 2019-10-1

Ok, one last question please. If i would want to "pick" from this .txt file (see image up) only the number of 9th line which command would help me to make it?

David K. 2019-10-1

Personally, I'm not great at reading in and out files all that well. I think there are some commands that let you set where you are reading in from and how how much to read in. But since the matrix is all ready read into matlab I would just use the matrix index to choose the value you need.

If you really only want to get one value then I would check out fseek and other f- commands.

请先登录，再进行评论。