MATLAB Central Newsreader - read the first line from a csv file of unknown length

read the first line from a csv file of unknown length

Philip Gladwin — Fri, 16 Nov 2007 16:37:05 -0500

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,

read the first line from a csv file of unknown length

Scott Burnside — Fri, 16 Nov 2007 18:16:09 -0500

"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
>
>
>
>

read the first line from a csv file of unknown length

Dan Haeg — Fri, 16 Nov 2007 18:20:23 -0500

"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