 Extracting snippets from PDF stored in BFILE [message #176287] |
Wed, 07 June 2006 12:55  |
Mark Kane
Messages: 21
Registered: January 2000
|
Junior Member |
|
|
I have a table with BFILEs that I need to search through, but I only want a snippet of the data, not the entire BFILE itself.
Some of the BFILE's are text and some are PDF. I can seperate out the text from the PDF, putting them into LONG and BLOBs respectively. The next step is to isolate an 80 character snippet of the files, centered on the word the users were interested in.
I'm doing this because my shop relies heavily on Discoverer and I do not want to make my users open every document to learn the context in which the word or term was used in.
How can I extract a snippet of words from a PDF file stored in a BFILE and put it into a VARCHAR?
I have scratched my head for quite a while and have made little progress, so any hints or help would be greatly appreciated.
-m
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
