Identify/parse content within documents?



I've got a full-text index on a table in which I've got word docs and
pdfs. I want to parse out certain types of content from these
documents, and include the parsed content in the info I give back to
the client.

In this case, I want to collect the e-mail address(es) from each
document yielded by a query. In other words, the client would input a
term like 'indexing', I query the database to yield those docs which
contain this term, then for each doc parse out the e-mail addresses it
contains and provide them back to the client. I imagine I could
identify these with a posix expression; but I can't find an example of
this type of query. Is there a way to do this?

Currently installed evaluation version is 2000 - 8.00.194 on Windows
XP. Thank you for any input..

.



Relevant Pages

  • Re: Identify/parse content within documents?
    ... I can extract the text of word docs and ... pdfs; but I was thinking ideally I could query the index itself. ... >> the client. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Library Cache
    ... procedures that determines the SQL to be submitted based on the ... query string to parse, whereas: ... it's HOW and WHEN that replacement occurs. ...
    (comp.databases.oracle.server)
  • Re: help pulling data from a query
    ... our scanners will only scan the data not hit return so i was ... that the query just returns the scanned units. ... if the battery should be replaced again or not. ... then parse that string to find each serial number. ...
    (microsoft.public.access.forms)
  • Re: Export data to letters
    ... let Word be a really nice desktop app, and use other things for client / ... server and web apps. ... In theory, I can imaging you could create Word docs using automation, ...
    (microsoft.public.inetserver.asp.general)
  • Re: Need help with query linked to form.
    ... Format() is guaranteed to create a Text field. ... You generally do need to parse the dates so Access knows how to interpret them. ... I have never used the CVDate() function though. ... do you use a Make Table query? ...
    (microsoft.public.access.queries)