How to read numbers from a txt file with numbers and text

Hi there,

I have a txt file as the attached one.

I want to read only the numbers, in order to elaborate after the data into a matrix.

I'm trying with this code, but it does not work, cause it does not read the last columns.

path1='.../path1'

fid = fopen(path1);

data = textscan(fid,'%s%f%f%f%f%s%s%f%f','HeaderLines',1,'CollectOutput',1);

data = data{1,1};

fid = fclose(fid);

Can anyone help me? Thanks in advance

Answer 1

[Image Analyst]

Try readtable():

t = readtable('example.txt')
data = t(:, [1:4,11,12])

[Sergio RUGGIERI]

Thanks for the suggestion. It works!

After, through the command "table2array(data)" I can jump to matrix.

[Image Analyst]

There is a table2array() function if you want to convert the table to a matrix.