Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Scanner and OCR


  • Please log in to reply
10 replies to this topic

#1 shirianuk

shirianuk

  • Members
  • 10 posts
  • OFFLINE
  •  
  • Local time:06:18 PM

Posted 17 May 2010 - 04:31 PM

I have a list which I took photocopied from a catalogue - the list is in alphabetic order of song title .
The artist is also shown and I wish to create a second list in alphabetic order using the artist name as the main alphabetical source.
I understand that if I buy a scanner with OCR software installed I can create a file which I can convert to XL therefore creating my new alphabetical listing based on artist (as opposed to song title), I would appreciate any input which can both confirm this is possible and also tell me the steps to take.
My windows system is XP.

Edited by shirianuk, 17 May 2010 - 05:24 PM.


BC AdBot (Login to Remove)

 


#2 hamluis

hamluis

    Moderator


  • Moderator
  • 56,551 posts
  • ONLINE
  •  
  • Gender:Male
  • Location:Killeen, TX
  • Local time:04:18 PM

Posted 17 May 2010 - 06:43 PM

By XL, I guess that you mean that you want to create an Excel file (or some database file).

http://ask-leo.com/how_do_i_scan_a_document_into_excel.html

I can't envision any way of doing what you want...without initially creating the database file from scratch. Either MS Access or MS Excel would then yield a manipulable database. The fact that you have a list...as opposed to actually have files reflecting the data classifications...is the limitation that I see.

A photocopy is just a picture...what's the file extension on this?

Louis

#3 shirianuk

shirianuk
  • Topic Starter

  • Members
  • 10 posts
  • OFFLINE
  •  
  • Local time:06:18 PM

Posted 17 May 2010 - 08:33 PM

Thanks for replying,
I understand (and believe me- I am no expert), that with OCR software I can "Create word processing files from scanned documents with Optical Character Recognition software."
This quote is pulled directly from the HP Scanjet G3110 blurb.
I stated I wanted Excel files but all I need is a list that I can convert alphabetically from 'Song Title'(A to Z) to 'Artist '(A to Z).
e.g.

This is how my current list displays:

32154 A New Day Neil Diamond
32090 Best Times Abba

(in which the song title creates the listing order (alphabetically).

I want it to read by artist - therefore;

32090 Best Times Abba
32154 A New Day Neil Diamond.

This would enable people to look up the artist rather than the song title.

Sorry if this seems very basic but it is the easiest way to describe what I want. My thoughts are that if I can create a 'word' or 'excel' file by scanning my list then I can rearrange the list alphabetically by choosing a different column for me to sort.

#4 tg1911

tg1911

    Lord Spam Magnet


  • Members
  • 19,274 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:SW Louisiana
  • Local time:04:18 PM

Posted 17 May 2010 - 08:51 PM

A photocopy is just a picture...what's the file extension on this?

A text image scanned using an OCR (Optical Character Recognition) program can be converted into an editable text file.

shirianuk,
If your scanner doesn't come with it, here's a list of free OCR programs you can check out:
http://www.freeocr.net/
MOBO: GIGABYTE GA-MA790X-UD4P, CPU: Phenom II X4 955 Deneb BE, HS/F: CoolerMaster V8, RAM: 2 x 1G Kingston HyperX DDR2 800, VGA: ECS GeForce Black GTX 560, PSU: Antec TruePower Modular 750W, Soundcard: Asus Xonar D1, Case: CoolerMaster COSMOS 1000, Storage: Internal - 2 x Seagate 250GB SATA, 2 x WD 1TB SATA; External - Seagate 500GB USB, WD 640GB eSATA, 3 x WD 1TB eSATA

Become a BleepingComputer fan: Facebook

#5 shirianuk

shirianuk
  • Topic Starter

  • Members
  • 10 posts
  • OFFLINE
  •  
  • Local time:06:18 PM

Posted 17 May 2010 - 09:59 PM

Thanks for that

#6 tg1911

tg1911

    Lord Spam Magnet


  • Members
  • 19,274 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:SW Louisiana
  • Local time:04:18 PM

Posted 17 May 2010 - 10:07 PM

You're welcome, shirianuk.
Hope you're able to accomplish what you want.
MOBO: GIGABYTE GA-MA790X-UD4P, CPU: Phenom II X4 955 Deneb BE, HS/F: CoolerMaster V8, RAM: 2 x 1G Kingston HyperX DDR2 800, VGA: ECS GeForce Black GTX 560, PSU: Antec TruePower Modular 750W, Soundcard: Asus Xonar D1, Case: CoolerMaster COSMOS 1000, Storage: Internal - 2 x Seagate 250GB SATA, 2 x WD 1TB SATA; External - Seagate 500GB USB, WD 640GB eSATA, 3 x WD 1TB eSATA

Become a BleepingComputer fan: Facebook

#7 hamluis

hamluis

    Moderator


  • Moderator
  • 56,551 posts
  • ONLINE
  •  
  • Gender:Male
  • Location:Killeen, TX
  • Local time:04:18 PM

Posted 18 May 2010 - 06:55 AM

Thanks for the correction, TG1911 :thumbsup:.

I haven't tried OCR apps in quite a few years and had totally written them off mentally (because I previously thought they were not worth the trouble it took to edit/correct the output). I suspect they are better than I remember them from my prior efforts.

I've done a bit of research on this now...and it appears that various OCR programs profess the capability to scan and produce Excel files.

The following may be of more useful information for what you want to accomplish: Scan To Excel Guide.

Happy hunting :huh:.

Louis

#8 tg1911

tg1911

    Lord Spam Magnet


  • Members
  • 19,274 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:SW Louisiana
  • Local time:04:18 PM

Posted 18 May 2010 - 02:07 PM

No problem, Louis.
That's what we're here for; to learn.

I hadn't even heard of ORC, until a couple of years ago.
Sounded interesting, researched it a little, even used it a couple of times.
It does have it's uses. :thumbsup:
MOBO: GIGABYTE GA-MA790X-UD4P, CPU: Phenom II X4 955 Deneb BE, HS/F: CoolerMaster V8, RAM: 2 x 1G Kingston HyperX DDR2 800, VGA: ECS GeForce Black GTX 560, PSU: Antec TruePower Modular 750W, Soundcard: Asus Xonar D1, Case: CoolerMaster COSMOS 1000, Storage: Internal - 2 x Seagate 250GB SATA, 2 x WD 1TB SATA; External - Seagate 500GB USB, WD 640GB eSATA, 3 x WD 1TB eSATA

Become a BleepingComputer fan: Facebook

#9 shirianuk

shirianuk
  • Topic Starter

  • Members
  • 10 posts
  • OFFLINE
  •  
  • Local time:06:18 PM

Posted 19 May 2010 - 10:37 PM

Thank you Hamluis and tq1911, for both your honesty and the fact that both of you now think I may have a solution. I appreciate the help from both of you. I guess this is what forums such as this are designed for.

#10 anyrepli

anyrepli

  • Members
  • 160 posts
  • OFFLINE
  •  
  • Local time:06:18 PM

Posted 07 May 2013 - 03:57 AM

Just an additional thought. How about trying to take a picture of that list with a digital camera and then try using one of these free software OCR programs before you go the scanning route? In fact, some of these are specifically designed to identify text embedded in images taken by digital cameras.: http://www.simpopdf.com/resource/top-5-free-ocr-software-tools-to-convert-images-to-text.html

 

This may be a longshot but it might work and save you some bucks too!


Edited by anyrepli, 07 May 2013 - 04:12 AM.


#11 anyrepli

anyrepli

  • Members
  • 160 posts
  • OFFLINE
  •  
  • Local time:06:18 PM

Posted 07 May 2013 - 04:24 AM

Update: If you can get a digital image of that information, I found a site that can extract the embedded text for you here: http://www.free-ocr.com/

I just tried it by creating a list of words (inside an image) and it was able to extract the text perfectly.


Edited by anyrepli, 07 May 2013 - 04:25 AM.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users