Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

Re^3: converting rows into column

by changma_ha (Sexton)
on Jul 18, 2010 at 15:06 UTC ( [id://850162]=note: print w/replies, xml ) Need Help??

in reply to Re^2: converting rows into column
in thread converting rows into column

thanx so much for ur advice... actually am a new in perl monk... actually i want to make a database of mp3 songs. so after retrieving the tag info of each song..i got a output like :

Artist: Rock Title: Fusion Album: Fusion Year: 2002 Genre: Other Artist: MelB Title: who am i Album: donny Year: 2004 Genre: Other Artist: bon jo Title: i can stay Album : Armyman Year: 2009 Genre: Other Artist: Pearl Title: Last Album: Jam Year: 1983 Genre: Other
now i want my database to be like :
Artist Title Album Year Genre ------ ----- ----- ----- ----- Rock Fusion Fusion 2002 other MelB who am I dont 2003 other bon jo Armyman jojo 2009 others etc. #!/usr/bin/perl use warnings; use strict; my %hasharray; open (my $fh, "<", "C:/songdata1.txt") or die "can't op +en the file"; while (<$fh>){ my ($header,$info) = split /:/; }
I dont know how to proceed futher. plz help me out. sorry for making mistake earlier. now i got it rite.. sorry biohisam..

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://850162]
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having a coffee break in the Monastery: (6)
As of 2024-04-17 15:54 GMT
Find Nodes?
    Voting Booth?

    No recent polls found