[LUAU] Using SED to extract song, artist, and album from my iTunes Music List Export

[Jim Thompson]

I'd use awk (or perl), not sed.

On Sep 25, 2006, at 9:03 PM, R. Scott Belford wrote:

> Aloha All
>
> I am wanting to generate a human-readable list of my iTunes  
> library. The export from iTunes creates a very busy file as seen  
> below.  Is anyone familiar enough with SED to share how to extract  
> name, artist, and album from the exported file?
>
> I want it to look something like this.  Automagically wrapping  
> quotes around the song title would be idea.
>
> 1. The Happy Organ Baby Dave Cortez Rockin Instrumentals
> 2. The Grid Philip Glass Koyaanisqatsi: Life Out Of Balance
> 3. The Grasshopper Unit (Keep Movin') The Beastie Boys Hello Nasty
> 4. The Goin' Get Tough From The Getgo Ween Pure Guava
> 5. The Glory Of Man Minutemen Double Nickels On The Dime
> 6. The Girl In The Blue Velvet Band Hylo Brown 20 Bluegrass Originals
>
>
> The file is exported in this order
>
> Name	Artist	Composer	Album	Grouping	Genre	Size	Time	Disc Number	 
> Disc Count	Track Number	Track Count	Year	Date Modified	Date Added	 
> Bit Rate Sample Rate	Volume Adjustment	Kind	Equalizer	Comments	Play  
> Count	Last Played	Skip Count	Last Skipped	My Rating	Location
>
>
> The export looks like this
>
> The Happy Organ	Baby Dave Cortez		Rockin Instrumentals (Disc 1)		 
> Rock 1977065	123	1	2	3	17		3/4/05 10:31 PM	3/8/06 10:55 AM	128	 
> 44100		MPEG audio file			1	5/13/06 8:04 AM				 
> MUSIC:Compilations:Rockin Instrumentals (Disc 1):1-03 The Happy  
> Organ.mp3
> The Grid	Philip Glass	Philip Glass	Koyaanisqatsi: Life Out Of  
> Balance		Classical	14346165	896	1	1	5	6	1983	3/5/05 12:41 AM	3/8/06  
> 10:55 AM	128	44100		MPEG audio file			1	5/13/06 7:45 AM				 
> MUSIC:Philip Glass:Koyaanisqatsi_ Life Out Of Balance:05 The Grid.mp3
> The Grasshopper Unit (Keep Movin')	The Beastie Boys	Mike Diamond  
> (aka Mike D), Adam Horowitz (aka King Ad-Rock) & Adam Yauch (aka  
> MCA)	Hello Nasty		Hip Hop/Rap	2903364	181	1	1	13	22	1998	3/3/05  
> 10:16 PM	2/25/06 12:11 PM	128	44100		MPEG audio file			1	5/13/06  
> 7:30 AM				MUSIC:The Beastie Boys:Hello Nasty:13 The Grasshopper  
> Unit (Keep Movin').mp3
> The Goin' Get Tough From The Getgo	Ween		Pure Guava		Alternative &  
> Punk	2053138	128	1	1	6	19	1992	3/4/05 10:21 AM	2/25/06 12:11 PM	128  
> 44100		MPEG audio file			2	5/13/06 7:27 AM				MUSIC:Ween:Pure Guava: 
> 06 The Goin' Get Tough From The Getgo.mp3
> The Glory Of Man	Minutemen		Double Nickels On The Dime		Alternative  
> & Punk	2844339	177	1	1	20	43	1989	3/4/05 10:29 AM	2/25/06 12:11 PM  
> 128	44100		MPEG audio file			2	5/13/06 7:25 AM				 
> MUSIC:Minutemen:Double Nickels On The Dime:20 The Glory Of Man.mp3
> The Girl In The Blue Velvet Band	Hylo Brown		20 Bluegrass  
> Originals		Folk	1994205	124	1	1	5	20		3/3/05 9:33 PM	3/8/06 10:55  
> AM	128	44100		MPEG audio file			1	5/13/06 7:22 AM			  
> MUSIC:Compilations:20 Bluegrass Originals:05 The Girl In The Blue  
> Velvet Band.mp3
>
>
> --scott
> _______________________________________________
> LUAU at lists.hosef.org mailing list
> http://lists.hosef.org/cgi-bin/mailman/listinfo/luau