Do you own a Debenu Quick PDF Library version 7, 8, 9, 10, 11, 12, 13 or iSEDQuickPDF license? Upgrade to Debenu Quick PDF Library 14 today!
Extract text from PDF in Database |
Post Reply |
Author | |
chrisreed
Team Player Joined: 29 Apr 13 Location: Australia Status: Offline Points: 35 |
Post Options
Thanks(0)
Posted: 21 Nov 17 at 7:51AM |
I have stored the contents of PDF files in a varbinary(max) column in an MS SQL Database.
Is there a function in QuickPDF that allows me to extract text from the string data I return from an SQL Query on this column while it is memory? ie. directly operate on the string data rather than a PDF file? ie. With the extracted contents of the data from the database I want to avoid having to: 1) Save it as a PDF file. 2) Open the file using say the DAOpenFile function. 3) Extract the text using say DAExtractPageText function. 4) Close the file and then delete it. I have over 14,000 PDF files to check so you can see having to save, open and delete a PDF file for each record in the database will take a lot of time. Chris
|
|
Ingo
Moderator Group Joined: 29 Oct 05 Status: Offline Points: 3524 |
Post Options
Thanks(0)
|
Hi Chris,
in any case you need a LoadFromString to build the internal pdf-structure. Then you can work on it with one of the extract-functionalities (no chance to avoid it). As an option (if you've done some changes) with a SaveToString and a rewrite into your database you can save your changes without creating a new pdf. |
|
Cheers,
Ingo |
|
chrisreed
Team Player Joined: 29 Apr 13 Location: Australia Status: Offline Points: 35 |
Post Options
Thanks(0)
|
Thanks Ingo, but I could not find the LoadFromString Method. I have only the following....
LoadFromCanvasDC, LoadFromFile, LoadFromVariant, LoadState I am running version 9.16 so perhaps this is a method in a newer version? Chris
|
|
mLipok
Senior Member Joined: 23 Apr 14 Location: Poland, Zabrze Status: Offline Points: 453 |
Post Options
Thanks(0)
|
If you are using ActiveX then you should use
LoadFromVariant SaveToVariant Just like I do in many project's when I reading / saving PDF content to/from MS SQL Databases. |
|
Here you can find description how to test my examples:
http://www.quickpdf.org/forum/forum_posts.asp?TID=2932&PID=12600&title=drawcapturedpagematrix-matrix-howto#12600 |
|
Ingo
Moderator Group Joined: 29 Oct 05 Status: Offline Points: 3524 |
Post Options
Thanks(0)
|
http://www.debenu.com/docs/pdf_library_reference/LoadFromString.php
|
|
Cheers,
Ingo |
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Copyright © 2017 Debenu. Debenu Quick PDF Library is a PDF SDK. All rights reserved. About — Contact — Blog — Support — Online Store