dataload

Hello, I try to use the following command to read in a csv file

[data D]=importdata('FI.csv',',');

the file looks like

Time last_price volume Security Side 1/3/2011 9:10 100.18 678 RXP1EX GY Equity B 1/3/2011 9:30 100.18 84524 RXP1EX GY Equity B

However, Matlab returns a cell with 1 column only, instead of 5. How can i fix this? Cheers,

[Christof]

Time last_price volume Security Side

1/3/2011 9:10 100.18 678 RXP1EX GY Equity B 1/3/2011 9:30 100.18 84524 RXP1EX GY Equity B

[Jan]

Please edit your original post. I assume it gets nicer if you start the lines showing your file by a space.

Answer 1

[Jan]

You specify in the call of IMPORTDATA, that the values are separated by commas. But the file does not contain commas. Perhaps this works:

[data, D]=importdata('FI.csv', ' ');

Answer 2

[john]

There is a function

csvread(parameters...)

which I've used before for this. Check it out.

[Christof]

when I use that command, Matlab spits out an error

Error using ==> dlmread at 145

Mismatch between file and format string.

Trouble reading number from file (row 1, field 1) ==> Time,

Error in ==> csvread at 52

m=dlmread(filename, ',', r, c);

think it does not like strings, only integers

[john]

Ok. Then I'd go with Jan's answer above -

This should give you the line broken up into (many) fields and then you just work with the fields you want.

Have you tried the import wizard and used it to generate m-code? Just double click the data file in Matlab.