Import values from a CSV file into one cell array

Question

I have a .dat file similar to the following:

* ID=Minilog-T
* Serial Number=1328
* Study ID=Rostherne 2008
* Start Time=13-11-2008,14:23:14
* Finish Time=09-12-2009,13:01:53
* Sample Period=02:00:00
* Number of Deployments=9
* Date(dd-mm-yyyy),Time(hh:mm:ss),Celsius (°C)
13-11-2008,14:23:14,20.6
13-11-2008,16:23:14,15.3

I would like to insert the data into a cell array where I have:

dat = {'13-11-2008','14:23:14','20.6';'13-11-2008','16:23:14','15.3'};

dat = 

    '13-11-2008'    '14:23:14'    '20.6'
    '13-11-2008'    '16:23:14'    '15.3'

I have tried:

fid = fopen(...);
dat = textscan(fid,'%s%s%s','headerlines',8);

However, this imports everything into 3 separate cell arrays i.e. it does not take the same format as a matrix. How can I solve this?

Eitan T · Accepted Answer · 2013-03-07 12:26:42Z

4

The thing is that textscan puts each extracted column in its own cell, so a slightly different approach is required.

One possible way to do it would involve using textscan to extract the relevant lines, and then splitting each one into comma-delimited strings using regexp:

dat = textscan(fid, '%s', 'headerlines', 8, 'delimiter', '\n')
C = regexp(dat{1}, ',', 'split');
dat = vertcat(C{:})

answered Mar 7, 2013 at 12:26

Eitan T

33k14 gold badges77 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Import values from a CSV file into one cell array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related