Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.sys.mac.system > #54622

Re: Copying from iTunes to Excel

Show all headers | View raw

In article <120120140012444284%michelle@michelle.org>,
 Michelle Steiner <michelle@michelle.org> wrote:

> In article <vilain-18C395.22362811012014@news.individual.net>, Michael
> Vilain <vilain@NOspamcop.net> wrote:
> 
> > When I select and copy the selected tracks to a text editor like BBEdit 
> > and look at the pasted text, it's delimited by spaces, not tabs.  If I 
> > paste the contents of the clipboard into Excel, it works fine.  If I 
> > paste into the first cell of Numbers, it displays the text of the first 
> > line of the paste buffer in the first cell, but that's it
> 
> When I paste it into TextWrangler, Pages, or TextEdit (in plain text
> mode), the pasted text is tab delimited.  When I paste it into TextEdit
> (in RTF mode) or mail.app (in either text or RTF mode), the tracks
> themselves are pasted, and can be played from within the document.

I'm on 10.8.5.  I just tried it again with a different playlist.

This selection of 158 songs came out as tab delimited in BBEdit.
Pasting into Numbers 2.3 allowed for the first field of the first line 
to paste into the first cell.

Opening the BBEdit tab-separated txt file into a new sheet worked in 
Numbers 2.3.

I have no idea what the OP is struggling with. It "works for me".

-- 
DeeDee, don't press that button!  DeeDee!  NO!  Dee...
[I filter all Goggle Groups posts, so any reply may be automatically ignored]

Back to comp.sys.mac.system | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Copying from iTunes to Excel Don Tuttle <Don@noplace.net> - 2014-01-11 18:25 -0500
  Re: Copying from iTunes to Excel Michelle Steiner <michelle@michelle.org> - 2014-01-11 17:22 -0700
  Re: Copying from iTunes to Excel Jolly Roger <jollyroger@pobox.com> - 2014-01-12 00:26 +0000
    Re: Copying from iTunes to Excel Michael Vilain <vilain@NOspamcop.net> - 2014-01-11 16:53 -0800
      Re: Copying from iTunes to Excel Jolly Roger <jollyroger@pobox.com> - 2014-01-12 01:33 +0000
        Re: Copying from iTunes to Excel Michael Vilain <vilain@NOspamcop.net> - 2014-01-11 20:10 -0800
          Re: Copying from iTunes to Excel Michelle Steiner <michelle@michelle.org> - 2014-01-11 21:22 -0700
            Re: Copying from iTunes to Excel Jolly Roger <jollyroger@pobox.com> - 2014-01-12 04:50 +0000
              Re: Copying from iTunes to Excel Michael Vilain <vilain@NOspamcop.net> - 2014-01-11 22:36 -0800
                Re: Copying from iTunes to Excel Michelle Steiner <michelle@michelle.org> - 2014-01-12 00:12 -0700
                Re: Copying from iTunes to Excel Michael Vilain <vilain@NOspamcop.net> - 2014-01-11 23:32 -0800
  Re: Copying from iTunes to Excel Savageduck <savageduck1@{REMOVESPAM}me.com> - 2014-01-11 18:31 -0800
  Re: Copying from iTunes to Excel Don Tuttle <Don@noplace.net> - 2014-01-12 09:37 -0500
    Re: Copying from iTunes to Excel Savageduck <savageduck1@{REMOVESPAM}me.com> - 2014-01-12 07:53 -0800
  Re: Copying from iTunes to Excel Alan Browne <alan.browne@FreelunchVideotron.ca> - 2014-01-12 11:11 -0500

csiph-web