Please help. I need to read this file and isolate column 2.
1 view (last 30 days)
Show older comments
It appears the data is not separated into columns. Any way to do this?
A = importdata('Psmall.txt');
A1 = A(:,2);
5 Comments
the cyclist
on 17 May 2018
To be clear, when I run your code, I get an Nx2 matrix (of data type "double"). As Star Strider said, it is then easy to separate them into the column vector.
Is that what you get?
Accepted Answer
John BG
on 17 May 2018
Hi Charles Naegele
1.
You are having the same result as if you were using textscan instead of importdata
fid1=fopen('Psmall.txt');
B=textscan(fid1,'%s');
fclose(fid1)
B1=B{1}
B2=cell2mat(B1)
B2 has as single column with all data, as you mention it happens in your data acquisition.
2.
Try
A=importdata('Psmall.txt','\t')
Note that your data file has a TAB as separator, not the default ' ' (space) or comma. Despite MATLAB help for import data reads
The default character is interpreted from the file.
It may be the case an earlier version of MATLAB doesn't really consider TAB as a column separator.
If you upgrade your MATLAB version you will solve this and possibly other compatibility issues to come.
If you find this answer useful would you please be so kind to consider marking my answer as Accepted Answer?
To any other reader, if you find this answer useful please consider clicking on the thumbs-up vote link
thanks in advance for time and attention
John BG
More Answers (0)
See Also
Categories
Find more on Large Files and Big Data in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!