read a text file

Hi

I need to make a matrix with the text file attached below.

I've considered 'fscanf' and 'readtable'.

But I faced 2 problems.

Some of rows have 8 elements while others have 10.

Also, there are blank cells and I don't know how to handle this to make it 0.

Thanks.

[Walter Roberson]

See https://www.mathworks.com/help/matlab/ref/matlab.io.text.fixedwidthimportoptions.html

Answer 1

[Pratheek Punchathody]

As per my understanding it is required to create a matrix/table from the data present in the text file.

For the demo purpose I have taken the sample text file which has different number of columns in each row and there are multiple empty cells in each row.

Considering the sample text file with the data as shown below.

Below is the code I have used to import the text file to a matrix.

opts = detectImportOptions('same.txt', 'EmptyLineRule','skip','ExtraColumnsRule','ignore'); 
opts.MissingRule = 'fill'; 
opts = setvaropts(opts,'FillValue',0); %fill the empty cells with the value 0

myTable = readtable('same.txt',opts); %create table from the .txt file 
myMatrix=table2array(myTable); %create  from the table

Below image shows the output matrix of the data present in the text file.

“table2array()” function is used to convert the created table to matrix format.

As required, all the empty cells adn extra column cells are filled with 0.

Refer to the Documentation - detectImportOptions for further information.

Also follow the Link - Set variable import options.