Results 1 to 11 of 11
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Getting a song list into Excel from Nero

    Hi all,

    I'm not sure if this is the correct forum for this query?

    I recently burned a MP3
    Regards,
    Rudi

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Getting a song list into Excel from Nero

    When you say a single 'text box', can you copy the text to the clipboard?
    If so, paste in into something like Notepad, save it as a txt file and import it into Excel.

    Otherwise, can you print it to a pdf, then grab the text from that?

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Getting a song list into Excel from Nero

    Thanks for getting involved in my query Leif.
    As you can see in the graphic...the "text box" is selected, but I can not get "into" it. I can not select the text at all let alone copy the text. (If I copy the text box, it does not register on the clipboard, ie - I cannot select paste!). It is simply movable/sizable by dragging the text box itself.
    I have not tried your pdf suggestion. I'll give that a go!
    Tx
    Regards,
    Rudi

  4. #4
    Uranium Lounger
    Join Date
    Mar 2001
    Location
    New Jersey
    Posts
    6,684
    Thanks
    1
    Thanked 11 Times in 11 Posts

    Re: Getting a song list into Excel from Nero

    You might try making it larger and then using the PrintScrn key to put it on the clipboard, open it in an image editing program and crop off the edges and then run the image through an OCR program to get it into a format you can edit. Or just scan the hardcopy you have and then use an OCR program.
    <IMG SRC=http://www.wopr.com/w3tuserpics/DocWatson_sig.gif>

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Getting a song list into Excel from Nero

    Thats an interesting thought too Doc. I don't have a scanner at home, so I will have to "borrow" one at the office, and scan it into file format in my lunch break!
    Thanx for the suggestion!

    Leif:
    I did not come right with your suggestion to save it to pdf. Could you run me through what you suggested step by step so I can see if I understood you correctly!
    Tx
    Regards,
    Rudi

  6. #6
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Getting a song list into Excel from Nero

    I'm running Acrobat 4 here so the steps your end may differ.

    Print the cover to create a pdf file.
    Open with Acrobat and click on the Select Text icon.
    Select the text, copy and paste into Notepad.

    As I've never tried it I can't guarantee this will work if the 'text' printed to Acrobat is a graphic rather than text, but it must be worth a shot.

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Getting a song list into Excel from Nero

    Thanx for the steps. I will certainly give it a shot! It it does not work, I still have Doc's suggestion that I can do at the office!
    Cheers
    Regards,
    Rudi

  8. #8
    Super Moderator
    Join Date
    Dec 2000
    Location
    Renton, Washington, USA
    Posts
    12,560
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: Getting a song list into Excel from Nero

    With MOST newer OCR programs, they can scan most any image and the OCR program will work, NO scanner required.

    Now running HP Pavilion a6528p, with Win7 64 Bit OS.

  9. #9
    5 Star Lounger
    Join Date
    May 2003
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Getting a song list into Excel from Nero

    <hr> NO scanner required.<hr>

    Now that would be one heck of an OCR program <g>

  10. #10
    Super Moderator
    Join Date
    Dec 2000
    Location
    Renton, Washington, USA
    Posts
    12,560
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: Getting a song list into Excel from Nero

    OmniPage Pro version 14, from the help

    Loading image files
    You can create image files from your own scanner, or receive them by e-mail or as fax files. OmniPage Pro can open a wide range of image file types, see Supported file types. If a document is already open, loaded image files are inserted as new pages in the location you defined in the Process panel of the Options dialog box. The most usual location is after the last page.
    Supported file types
    OmniPage Pro can open and save these image file types:


    Note, I receive a lot of images, as attachments and OCR them using OmniPage on my laptop without a scanner. It will also OCR a unprotected PDF file.

    Now running HP Pavilion a6528p, with Win7 64 Bit OS.

  11. #11
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Getting a song list into Excel from Nero

    Very interesting Dave... Thanks for the info!
    Regards,
    Rudi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •