MATLAB: Data (.txt) into matrix

matrix

I have a set of data and I wanna convert it to a matrix in Matlab, so that i can see the model.

The data comes from a different program, and it is organized in a line, where the first number means the x variable, the second means the y variable, and the ";" separates the point.

How can I make a matrix out of it so that I can plot the model?

I've attached the first data.

Thank you very much.

Best Answer

This works on the small file I attached here. If the format is not exactly what you have, maybe you can still figure out how to do it from this start.

fid = fopen('data.txt');
C = textscan(fid,'%f,%f;');
fclose(fid)

Related Solutions

MATLAB: Deleting several lines from text file (.txt)

If you only need to copy those lines form one file to another, then try something like this:

fid = fopen('test.txt','rt');
fin = fopen('test_new.txt','wt');
S = fgetl(fid);
while ischar(S)
    if ~isempty(S) && strcmp(S(3),'1')
        fprintf(fin,'%s\n',S);
    end
    S = fgetl(fid);
end
fclose(fid);
fclose(fin);

MATLAB: How to import a text (.txt) file to MATLAB

See Delimited or formatted I/O to text files

Interactively:

I think the simplest way is to read the file interactively with "Import Data ..." in the File menu (R2012a).

Width code:

    fid = fopen('cssm.txt', 'r' );
    cac = textscan( fid, '%f%f%f%f%f%f', 'CollectOutput', true, 'Headerlines', 2 );
    fclose( fid );
    cac{:}

returns

    ans =
       1.0e-03 *
             0         0         0         0         0         0
             0         0         0         0         0         0
        1.0000         0    1.0000         0    1.0000         0
        1.0000         0    1.0000         0    1.0000         0
        1.0000         0    1.0000         0    1.0000         0

where cssm.txt contains

    XY          
      COP x    COP y    COP z
    0  0  0  0  0  0
    0  0  0  0  0  0
    0.001  0  0.001  0  0.001  0
    0.001  0  0.001  0  0.001  0
    0.001  0  0.001  0  0.001  0

Including the header:

    fid = fopen('cssm.txt', 'r' );
    h1  = textscan( fid, '%s', 1 );
    h2  = textscan( fid, '%s%s%s%s%s%s', 1, 'CollectOutput', true );
    cac = textscan( fid, '%f%f%f%f%f%f', 'CollectOutput', true, 'Headerlines', 0 );
    fclose( fid );
    h1{:}
    h2{:}
    cac{:}

returns

    ans = 
        'XY'
    ans = 
        'COP'    'x'    'COP'    'y'    'COP'    'z'
    ans =
       1.0e-03 *
             0         0         0         0         0         0
             0         0         0         0         0         0
        1.0000         0    1.0000         0    1.0000         0
        1.0000         0    1.0000         0    1.0000         0
        1.0000         0    1.0000         0    1.0000         0

Mimicing xlsread output

    fid = fopen('forceplate_3.txt', 'r' );
    h1  = fgetl( fid );
    h2  = textscan( fid, '%s%s%s%s%s%s', 1, 'CollectOutput', true );
    cac = textscan( fid, '%f%f%f%f%f%f', 'CollectOutput', true, 'Headerlines', 0 );
    fclose( fid );
    txtdata     = repmat({''}, 2, 6 );
    txtdata(1,1)= {h1};
    txtdata(2,:)= h2{:};
    numdata     = cac{:};

the results are:

    >> whos *data
      Name             Size              Bytes  Class     Attributes
      numdata      21000x6             1008000  double              
      txtdata          2x6                1382  cell

Best Answer

Related Solutions

MATLAB: Deleting several lines from text file (.txt)

MATLAB: How to import a text (.txt) file to MATLAB

Related Question