karaoke song books

symy@nufc

hi guys and girls! i.ve just got karaoke/disco equipment off a mate but the books are all a mess and i would like to to start from scratch and there is a lot of songs in the book been looking at this http://www.airwer.com/software .has anybody used it or is there a Similar or a free 1 that anyone has used
cheers

symy@nufc

ok guys what is the best way to organize my karaoke book copy from pdf paste to excel or this there an easy way? for example pdf file
(track number artist song title ref n0) i need it to be
(song title artist ref no track no)
can any one help this poor old frustrated:mad: man please!cheers

ManAtHome

Excel would be a reasonable target - you can sort by columns and export in .CSV format which loads into a fair number of other packages.

If you're lucky, text in the pdf file will have commas between track number, artist, etc. In Acrobat Reader, use Edit/Select all/Copy, Edit/Paste into Wordpad or Notepad, edit out any dross (and/or add commas) then save as anything.CSV. Double-clicking this should load into Excel with each field in its own column.

Try it by creating a Notepad file:
1,Abba,Waterloo,150
2,Beach Boys,Surfin' Safari,821

save as test.csv then double-click...

ManAtHome

Just had another thought (I use Access much more than Excel)...

When you open a file in Excel, if it's a .TXT file (eg test.TXT), you have the option to load it as fixed-width instead of comma-separated. So you may not need to add commas (use the CSV route if they are in the PDF though).

For a fixed-width file, you just need the same spacing between each "column" (can't really show it on here as html "scrunches" everything, but when you look at the file you should see distinct columns - all the track numbers directly underneath each other, same for Title, Artist etc.

Again, try it with the test.csv file in my earlier post padding out each "column" so they line up, then save as text.TXT and load into Excel (you'll need to go into Excel and use File/Load/fixed-width for a .TXT file).

Hope that's all understandable...