Thread Subject: read the first line from a csv file of unknown length

Hello,
Does anybody know how to solve this problem?

I would like to read the column headings, as strings,
from the first row of a comma-separated file into
an string array.

The tricky part is I would like to do this without
specifying the number of columns in the file, as
the column headings will change from file to file.

Can anybody help?

Thank you.

Phil,

"Philip Gladwin" <philip.gladwin@citi.com> wrote in
message <fhkgvh$oor$1@fred.mathworks.com>...
> Hello,
> Does anybody know how to solve this problem?
>
> I would like to read the column headings, as strings,
> from the first row of a comma-separated file into
> an string array.
>
> The tricky part is I would like to do this without
> specifying the number of columns in the file, as
> the column headings will change from file to file.
>
> Can anybody help?
>
> Thank you.
>
> Phil,
>
>

Phil, you can take a look at autodataread.m in the FEX. I
parse the header as you describe.

hth,
Scott
>
>
>
>

"Philip Gladwin" <philip.gladwin@citi.com> wrote in message
<fhkgvh$oor$1@fred.mathworks.com>...
> Hello,
> Does anybody know how to solve this problem?
>
> I would like to read the column headings, as strings,
> from the first row of a comma-separated file into
> an string array.
>
> The tricky part is I would like to do this without
> specifying the number of columns in the file, as
> the column headings will change from file to file.
>
> Can anybody help?
>
> Thank you.
>
> Phil,
>
>
>
>
>
>
This may work:
h = actxserver('Scripting.FileSystemObject');
ts=h.OpenTextFile(filename);
headings=ts.ReadLine;

Dan