Grab Text and create a sum of numbers

  • 1
  • Idea
  • Updated 4 months ago
I have an accountant client who asked me if I knew a way to use the mouse to draw a box around a screen area that had numbers in it and have it OCR the numbers and create a sum of the numbers. I told him I didn't currently know a way but I thought about the new feature in Snagit to grab text. I thought I would start here to see if that feature exists, is on the roadmap or if there is another product that might be able to do this.
Photo of rod

rod

  • 3 Posts
  • 0 Reply Likes

Posted 4 months ago

  • 1
Photo of Kelly Mullins

Kelly Mullins, TechSmith Employee & Helper

  • 2849 Posts
  • 620 Reply Likes
Hello,
Yes, this is possible using the Grab Text feature.

Can you please read my reply post on this other page to see how I accomplished this?


https://feedback.techsmith.com/techsmith/topics/capture-table-data-so-it-pastes-properly-to-excel

Let me know if you need more information.
Kelly
Photo of rod

rod

  • 3 Posts
  • 0 Reply Likes
Kelly and Ed,

Thank you for your quick responses last week and I'm sorry for the delay. It has been a busy week. I did look at your example link and the grab text feature in Snagit 2019 works well. BUT for what I am looking for, it still does not go far enough. I showed this idea to the accountant and he immediately indicated it was too much work. What they really want is a way to have a pdf with numbers in a column and have a utility to drag across those numbers and have the sum pop up to the side or at the very least have an option to sum. I have created a quick Screencast of how I showed it to him. I knew he would want as little friction as possible so I created a spreadsheet with some macros in it to automatically paste the clipboard and sum the numbers. Here is that link if you want to view it.   https://www.screencast.com/t/ayU6Uc5OhUEf
Photo of Ed Covney

Ed Covney

  • 273 Posts
  • 197 Reply Likes
Hi Rod & Kelly (again) -
Kelly found the secret a while back and  I so happy he did. The magic happened (for me), when Kelly proposed I NOT snag the leading dark vertical line. Yes magic. I read Sudoku puzzles into a data base.
Here's what Snagit Grabbed:


Here's what Snagit "Saw":


This is beyond understanding. Snag, Grab, Copy to excel!!!
BTW, if your friend is into Sudoku, I'd love to hear from him. I have about 12,000 puzzles in digital form and 2200 in the approved (solvable) list. I'm at ed(dot).covney(at)gmail(dot)com. 

Photo of Ed Covney

Ed Covney

  • 273 Posts
  • 197 Reply Likes
Rod,  Your example helps a pile, it's clean and orthogonal.  Here's the grab with no edits:

It picked up the tabs perfectly. I Put a formula in (3,6), RC style where it would total up to the first 15,000 lines. Took me < a minute.

(Edited)
Photo of Joe Morgan

Joe Morgan

  • 6812 Posts
  • 3748 Reply Likes
This probably isn't as slick as what your looking for rod but it's probably quicker than pasting in Excel.

I just downloaded this tool called "Add em up" Its a 60 day trial version. If you wanted to buy it, its $15. So its cheap anyway.

I used SnagIt to snag the numbers you were working with in your video. Copied them.


Hit the button "Calculate Clipboard" and Add 'em Up calculator solved the  problem.
Ctrl+C copy's the answer.



I did have one problem. I had to switch to Calculate using columns before it would add my pasted in figures.
A pop up window suggested I do so.So it was an easy problem to correct.

 

Its a low frills tool.Can be started with a hot key F9.

Regards,Joe


(Edited)
Photo of Joe Morgan

Joe Morgan

  • 6812 Posts
  • 3748 Reply Likes
Forgot to paste the link to the tool.

http://www.pc-shareware.com/addemup.htm






Photo of rod

rod

  • 3 Posts
  • 0 Reply Likes
Joe, Thanks. This utility comes the closest to what we are looking for. I like it and am definitely going to show it to them. However, it is about as many steps as using the spreadsheet that I equipped with a Macro to add the numbers on the clipboard. This is all about reducing friction for the client. One thing that would help a little is when you use Snagit to "Grab Text", it would be nice if the OCR'd contents of that text were automatically copied to the clipboard. I see there is an option to "Copy to Clipboard" at the capture tool but that just seems to capture the image, NOT the OCR'd image. So with using this new utility, the steps are:
1. Drag Snagit around the numbers
2. In the Grab Text Results, click Copy All
3. Click on the Add em up utility
4. Click Calculate clipboard

If Snagit would introduce an option to automatically place the OCR'd contents onto the clipboard, it would reduce the above steps from 4 to 3. My client would really like to be able to perform the drag and the total just pop up.

Thanks again for sharing this utility.
(Edited)