Read text file with string

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

Answer 1

[Turlough Hughes]

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.

[Guillaume]

Ahmed Anas' comment moved here:

i could not understand the 'detectImportOptions' command.

and getting an error about it

[Guillaume]

You haven't indicated which version of matlab you are using. It must be fairly old (<2016b) if it doesn't support detectImportOptions.

[Ahmed Anas]

am using 2016a right now..

[Ahmed Anas]

Btw it is working fine on 2019b..

Answer 2

[Guillaume]

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);