[thelist] Stupid Hack in Winblowz for CSV Delimiters

Chris Dorer cdorer at gmail.com
Thu Mar 1 11:09:55 CST 2007


Don't tell me this, seriously, Joel ;).

I fumbled with the 'text to columns' under 'data'  for 3 hours to no avail.

I was trying to use the pipe '|' as a delimiter

On 3/1/07, Joel D Canfield <joel at streamliine.com> wrote:
>
> > So you can no longer open a new Excel Worksheet, and do Data -> Get
> > External Data -> Import Text File... ?
> >
> > Or rename your CSV file TXT and open it in Excel the normal way?
> > (Rename because if your values aren't separated by commas, it
> > shouldn't be a CSV.  I'm sure there's a clue there somewhere!)
> >
> > I don't know, I don't have Excel 2003.  Have they really removed these
> > two methods?
>
> both still exist and work fine (Excel 2003 on WinXP)
>
> also, the 'text to columns' under 'data' allows you to choose a
> delimiter on the fly, as it always has. not sure what Chris was trying
> to accomplish, but it seems like there might have been an easier way.
>
> joel
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>



More information about the thelist mailing list