How to import an array separated by space from a text file?

I want to import/load/read, whatever works, a textfile.txt where the columns are separated by a space as below:

15 125 2,033.000 2,033.500 285 20

20 350 2,032.500 2,034.000 245 29

17 100 2,032.000 2,034.500 650 34

13 280 2,031.500 2,035.000 370 31

I used the command

X=importdata('test.txt','%s');

but it returned one column with all numbers after each other in it.

I wonder if someone could tell me how to obtain one table from a text file (in this particular case an array with 4 lines and 6 columns).

Thank you in advance for your help

Emerson

Answer 1

[Walter Roberson]

The commas are causing you problems. You need to convert the text to not have any commas before any of the built-in routines will be able to convert it to numeric.

If all you care about is getting the data into a cell array, then see http://www.mathworks.co.uk/matlabcentral/answers/45455-how-can-i-read-a-text-file-line-by-line-containing-titles-of-the-research-papers