Read text file with string
17 views (last 30 days)
Show older comments
Hi all,
I have to read the file (inserted in attachment) and only need the numeric portion as a matrix(array). The extension of file is .TXK .
Thanks in advance
0 Comments
Accepted Answer
Turlough Hughes
on 4 Mar 2020
Edited: Turlough Hughes
on 4 Mar 2020
You could use the readmatrix function as follows:
filename = 'My2.TXK'
opts = detectImportOptions(filename,'FileType','text')
data = readmatrix(filename,opts)
the .TXK extension is not recognised by readmatrix which is why I specified the FileType as text in the import options.
You could optionally read in as a table:
T = readtable(filename,opts)
If you want to get the variable names automatically, for example if you have a number of similar data files, I would need to see what the first line of text looks like generally across the files.
4 Comments
More Answers (1)
Guillaume
on 4 Mar 2020
Should work in R2016a:
filename = 'My2.TXK'; %using full path would be better
[fid, errmsg] = fopen(filename, 'rt');
assert(fid > 0, 'Failed to open "%s" due to error: %s', filename, errmsg);
data = cell2mat(textscan(fid, '%f%f%f', 'Delimiter', {'\t', ' '}, 'MultipleDelimsAsOne', true, 'HeaderLines', 1));
fclose(fid);
0 Comments
See Also
Categories
Find more on Text Files 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!