Trivial question on Matlab

mounphys · January 7th, 2009, 2:38 pm

Hi guys,as a newbie, I have a very trivial question about matlab.I want to import a .csv file in matlab. This file contains both text and numbers and this seems to cause problems with the Matlab "import wizard".The problem is that Matlab does not seem to read commas as symbols for separating columns, thus each row in the imported field appears to be made by one single text column.Hope I could explain myself.Any suggestion?Thanks a lot in advance.

Martinghoul · January 7th, 2009, 2:49 pm

That's actually non-trivial. Take a look here:readtext

Yossarian22 · January 7th, 2009, 3:35 pm

Hi, The way I solve that problem is to write a tiny four/five line perl script to extract the data I want to import. Then I run system('perscript.pl') in matlab. Y

spursfan · January 7th, 2009, 3:53 pm

Ah, the joys of MATLAB - a 450 line "work-round" function to do something that the program should do automatically

Martinghoul · January 7th, 2009, 3:58 pm

QuoteOriginally posted by: spursfanAh, the joys of MATLAB - a 450 line "work-round" function to do something that the program should do automaticallyWell, there's lots of comments...

chaz1858 · January 7th, 2009, 9:05 pm

Regarding the textread function, is there a way to import the data into a single matrix rather than separating it into three arrays? How come Matlab fails to import a ASCII text file with the date in the following format (19940105)? Is there a way I can just treat the date as a numeric data type?Are there any add-ons for Matlab that will do this for me automatically?

midastouch · January 15th, 2009, 1:07 am

try using:importdata('filename','whatever your delimiter')