Re: Converting tab delimited file to CSV
| From: | Andrew Ballard | Date: | Mon, 18 Feb 2008 17:23:43 +0000 |
| Subject: | Re: Converting tab delimited file to CSV | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-269500@lists.php.net to get a copy of this message | ||
On Feb 18, 2008 12:02 PM, Edward Kay <edward@labhut.com> wrote:
>
> > On Mon, February 18, 2008 10:36 am, Jay Blanchard wrote:
> > > [snip]
> > > That's funny... MS defaults to tabs for a file whose extension is .csv
> > > which is an acronym for (C)omma (S)eparated (V)alues.
> > > [/snip]
> > >
> > > Welcome to Microsoft....where do we want you to go today?
> >
> > I think it defaults to whatever you last used, not to a specific choice.
> >
>
> That would seem to be a possibility. I can quite happliy double-click a
> .csv
> file and have it open correctly in Excel.
>
>
Yes. And Excel seems to prefer .txt for tab delimited. However, .txt is
usually opened by Notepad by default, so you have to right-click and tell it
to Open With... Excel. When I do this, it reads it as columnar data rather
than a single column.
Andrew