How to read a text file and construct a matrix

Hi all,

I'd like to ask your help for a task I need to do.

I'm trying to read a text file with format as in the picture

and then create a matrix with 4 columns like the following

Please any advice-suggestion would be very welcome.

Cheers,

Dimi

[Jan]

Matlab's matrices cannot contain numeric and string elements. Do you want a cell array? What have you tried so far? Which problems occurred?

[Dimitrios Anagnostakis]

At the moment, I'm getting the contents to an array. I'm using this code.

fileID = fopen('example.txt');

formatSpec = '%s %s %s %s';

C = textscan(fileID,formatSpec,...            
                'Delimiter', '\n', ...
                'Delimiter', '\n', ... 
                'CollectOutput', true)
fclose(fileID);

The result is in the picture below.

I'd like to get the second column into two different ones in order to have the 4 columns matrix.

Any ideas?

Cheers Dimi

[Dimitrios Anagnostakis]

Well, I managed to get the second column separated as shown below.

Now I need to convert these to matrices in order to perform some calculations. I tried the cell2mat, but although it doesn't return any error message, it doesn't look like to be working.

Any suggestions?

Thanks, Dimi