Re: Identify/parse content within documents?

You have to have some mechanism to convert the binary data to text data.
After you have done this its a simple matter of running a regex or writing a
parser.

I don't recommend a tsql solution to this.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

<noel.whelan@xxxxxxxxx> wrote in message
news:1137089226.559095.313470@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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

  • lame server messages in named.log
    ... Mar 30 05:42:30.526 security: info: client 202.52.250.176#1052: ... query (cache) denied ...
    (RedHat)
  • lame server messages in named.log
    ... Mar 30 05:42:30.526 security: info: client 202.52.250.176#1052: ... query (cache) denied ...
    (RedHat)
  • Re: High CPU in client (Excel, OWC, Proclarity, etc.) accessing Analysis Services
    ... We have encountered similar problems not limited to Excel, but every client. ... occur when there are many dimensions nested on each other on a single axis ... > Performance Guide to optimize the query, the cube, the server, etc. ... > While the query was grinding, the server was doing absolutely nothing. ...
    (microsoft.public.sqlserver.olap)
  • Re: Delete Query Does Not
    ... When I try to run the SQL query below it gives me the ... Cannot group on fields selected with '*' (client) ... INNER JOIN meals ... Tom Ellison ...
    (microsoft.public.access.queries)
  • Re: Report filtered on a calculated field
    ... Make a query to determine who owes you. ... make this into a Totals Query. ... now you can base your first report directly on this query. ... totals for each client, also define a Client footer section as well. ...
    (microsoft.public.access.reports)
Loading