MATLAB: Reading Data from txt file with a unique FormatSpec

formatspecMATLAB and Simulink Student Suitetext file

Hello,

I have a text file containing the data in the format – [[0,0,0,0,0,-3,0,0,0,0,0,-1],[0.025,0.025,0.025,0.025,0.025,-1,-1,-1,-1,-1,-1,-1],..N*[ ]… ,[0,0,0,0,0,-3,0,0,0,0,0,-1]]

and I need to read it into a 6 columns matrix.

What is the right function and FormatSpec to use?

I am struggeling with the FormatSpec…

THANKS!!

Best Answer

One way:

A = reshape(double(replace(string(readcell('Test.txt')),["[[", "[", "]", "]]"],["", "", "", ""])),[],12)

This uses the attached example file baesd on your question.

Result:

A =
         0         0         0         0    0.0250    0.0250   -1.0000   -1.0000         0         0         0         0
         0         0         0         0    0.0250    0.0250   -1.0000   -1.0000         0         0         0         0
         0   -3.0000         0   -1.0000    0.0250   -1.0000   -1.0000   -1.0000         0   -3.0000         0   -1.0000

Related Solutions

MATLAB: How to compare the elements of a matrix and fill another matrix with the elements of a vector

Since your t matrix is full of 0 and 1 you can take advantage of that and just do this

a = [0.9 0.8 0.7 0.6 0.5];
b = [0.1 0.2 0.3 0.4 0.5];
t = ff2n(n);
t1 = t.*a
t1 =
         0         0         0         0         0
         0         0         0         0    0.5000
         0         0         0    0.6000         0
         0         0         0    0.6000    0.5000
         0         0    0.7000         0         0
         0         0    0.7000         0    0.5000
         0         0    0.7000    0.6000         0
         0         0    0.7000    0.6000    0.5000
         0    0.8000         0         0         0
         0    0.8000         0         0    0.5000
         0    0.8000         0    0.6000         0
         0    0.8000         0    0.6000    0.5000
         0    0.8000    0.7000         0         0
         0    0.8000    0.7000         0    0.5000
         0    0.8000    0.7000    0.6000         0
         0    0.8000    0.7000    0.6000    0.5000
    0.9000         0         0         0         0
    0.9000         0         0         0    0.5000
    0.9000         0         0    0.6000         0
    0.9000         0         0    0.6000    0.5000
    0.9000         0    0.7000         0         0
    0.9000         0    0.7000         0    0.5000
    0.9000         0    0.7000    0.6000         0
    0.9000         0    0.7000    0.6000    0.5000
    0.9000    0.8000         0         0         0
    0.9000    0.8000         0         0    0.5000
    0.9000    0.8000         0    0.6000         0
    0.9000    0.8000         0    0.6000    0.5000
    0.9000    0.8000    0.7000         0         0
    0.9000    0.8000    0.7000         0    0.5000
    0.9000    0.8000    0.7000    0.6000         0
    0.9000    0.8000    0.7000    0.6000    0.5000
t2 = not(t.*a).*b
t2 =
    0.1000    0.2000    0.3000    0.4000    0.5000
    0.1000    0.2000    0.3000    0.4000         0
    0.1000    0.2000    0.3000         0    0.5000
    0.1000    0.2000    0.3000         0         0
    0.1000    0.2000         0    0.4000    0.5000
    0.1000    0.2000         0    0.4000         0
    0.1000    0.2000         0         0    0.5000
    0.1000    0.2000         0         0         0
    0.1000         0    0.3000    0.4000    0.5000
    0.1000         0    0.3000    0.4000         0
    0.1000         0    0.3000         0    0.5000
    0.1000         0    0.3000         0         0
    0.1000         0         0    0.4000    0.5000
    0.1000         0         0    0.4000         0
    0.1000         0         0         0    0.5000
    0.1000         0         0         0         0
         0    0.2000    0.3000    0.4000    0.5000
         0    0.2000    0.3000    0.4000         0
         0    0.2000    0.3000         0    0.5000
         0    0.2000    0.3000         0         0
         0    0.2000         0    0.4000    0.5000
         0    0.2000         0    0.4000         0
         0    0.2000         0         0    0.5000
         0    0.2000         0         0         0
         0         0    0.3000    0.4000    0.5000
         0         0    0.3000    0.4000         0
         0         0    0.3000         0    0.5000
         0         0    0.3000         0         0
         0         0         0    0.4000    0.5000
         0         0         0    0.4000         0
         0         0         0         0    0.5000
         0         0         0         0         0
t1+t2
ans =
    0.1000    0.2000    0.3000    0.4000    0.5000
    0.1000    0.2000    0.3000    0.4000    0.5000
    0.1000    0.2000    0.3000    0.6000    0.5000
    0.1000    0.2000    0.3000    0.6000    0.5000
    0.1000    0.2000    0.7000    0.4000    0.5000
    0.1000    0.2000    0.7000    0.4000    0.5000
    0.1000    0.2000    0.7000    0.6000    0.5000
    0.1000    0.2000    0.7000    0.6000    0.5000
    0.1000    0.8000    0.3000    0.4000    0.5000
    0.1000    0.8000    0.3000    0.4000    0.5000
    0.1000    0.8000    0.3000    0.6000    0.5000
    0.1000    0.8000    0.3000    0.6000    0.5000
    0.1000    0.8000    0.7000    0.4000    0.5000
    0.1000    0.8000    0.7000    0.4000    0.5000
    0.1000    0.8000    0.7000    0.6000    0.5000
    0.1000    0.8000    0.7000    0.6000    0.5000
    0.9000    0.2000    0.3000    0.4000    0.5000
    0.9000    0.2000    0.3000    0.4000    0.5000
    0.9000    0.2000    0.3000    0.6000    0.5000
    0.9000    0.2000    0.3000    0.6000    0.5000
    0.9000    0.2000    0.7000    0.4000    0.5000
    0.9000    0.2000    0.7000    0.4000    0.5000
    0.9000    0.2000    0.7000    0.6000    0.5000
    0.9000    0.2000    0.7000    0.6000    0.5000
    0.9000    0.8000    0.3000    0.4000    0.5000
    0.9000    0.8000    0.3000    0.4000    0.5000
    0.9000    0.8000    0.3000    0.6000    0.5000
    0.9000    0.8000    0.3000    0.6000    0.5000
    0.9000    0.8000    0.7000    0.4000    0.5000
    0.9000    0.8000    0.7000    0.4000    0.5000
    0.9000    0.8000    0.7000    0.6000    0.5000
    0.9000    0.8000    0.7000    0.6000    0.5000

MATLAB: Hi, I have a 300×300 array of data in the workspace as a result of running the code. This large array contains mostly -1.000000 values but also some values that are not -1.00000 that are useful to me. How to pick out these values from the array?Tnx

help find

Or, if you want,

help ismember

You will probably need to use a tolerance, or not. That we cannot know. Only you know that.

Best Answer

Related Solutions

MATLAB: How to compare the elements of a matrix and fill another matrix with the elements of a vector

MATLAB: Hi, I have a 300×300 array of data in the workspace as a result of running the code. This large array contains mostly -1.000000 values but also some values that are not -1.00000 that are useful to me. How to pick out these values from the array?Tnx

Related Question