MATLAB Answers

Separating a colymn into two columns (.txt file)

3 views (last 30 days)
Ivan Mich
Ivan Mich on 24 Sep 2019
Commented: David K. on 1 Oct 2019
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?

Accepted Answer

David K.
David K. on 24 Sep 2019
Edited: David K. on 24 Sep 2019
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 Comments
David K.
David K. on 1 Oct 2019
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.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!