How to read a text file with multiplel matrix data sets listed one after another

Below is an example (in the real world, I have hundreds of data sets in a text file):

http://alturl.com/ns3j8

How do I load the data into Matlab?

Thank you in advance.

[Walter Roberson]

It won't let me see that page :(

[Liqing]

Problem fixed. Thanks for letting me know. Now you should be able to download the small txt file.

Answer 1

[Liqing]

I am still waiting for an answer. Thanks.

Answer 2

[Friedrich]

Hi,

trz

fid = fopen('sample.txt','r');
out = textscan(fid,'%s %s %s \r\n %f %f %f \r\n %f %f %f \r\n %f %f %f \r\n %f %f %f \r\n');
fclose(fid);
celldisp(out)

It depends on your OS if you have to use \r (MAC) or \n (Unix) or \r\n (Windows)

[Liqing]

Thank you very much. It works.

What if I have unknown and different number of matrix rows for each of them?

[Walter Roberson]

textscan by default ignores both \r and \n as being "Whitespace", so you can ignore the terminator issue:

textscan(fid, [repmat('%s',1,3) repmat('%f',1,12)]);

Answer 3

[Fangjun Jiang]

What is your desired output? Do you care about the text strings? The overall approach is to use textscan(). You can type help textscan or doc textscan for details.

fid=fopen('sample.txt','rt');
data=textscan(fid,'%f','CommentStyle','Depth');
fclose(fid);
data{1}

[Liqing]

I appreciate the reply very much. Yes I want the text strings as well.

[Fangjun Jiang]

What version of MATLAB do you have?

[Fangjun Jiang]

You can use fgetl() to read the file line by line. If the line contains comma, read it as string (%s), otherwise, read it as double (%f). There is really no hard part. It's just tedious. If you just have one file to read, it might worth to convert it to a .xls file and then use [Num,Txt,Raw]=xlsread().

[Fangjun Jiang]

Here is an example.

http://www.mathworks.com/matlabcentral/answers/13383-how-to-extract-numerical-datafrom-txt-file-with-mixed-string-and-numerical-data