Read text file using MATLAB

I needs to read the attached text file using MATLAB and split the columns by coma (,)

[Stephen23]

There is no file attached. You need to press the paperclip button, then both the Choose file and Attach file buttons.

[Prabodha Wijerathne]

Sorry about that. I just attached the file

Answer 1

[Stephen23]

Use textscan:

fid = fopen(filename,'rt');
C = textscan(fid,format,'Delimiter',',');
fclose(fid);

Read the textscan documentation to know how to specify the format string, OR please supply us with your sample file and we can show you how the format string can be defined.

EDIT: using the newly uploaded datafile:

fnm = 'LogFile_Test.txt';
fmt = '%*s%s%*s%f%*s%f%*s%f%*s%f%*s%f%*s%f;\n';
fid = fopen(fnm,'rt');
C = textscan(fid,fmt,'Delimiter',{',',':'});
fclose(fid);
D = horzcat(C{2:end});

This code reads the numeric columns of the file into a numeric matrix D. The first data column contains multiple '-' characters, and is imported as a string in C{1}.