Full text search to find near numerical values?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tore - 17 Aug 2008 21:43 GMT

I am a novice on Full text search, never used it before.
I have a large number of word documents (.doc files) with different layouts
and contents where I need to extract some data to populate a database. The
documents are invoices. In the documents I would like to search for words
like Total Amount, VAT, From date, To date etc and find the corresponding
currency values and date fields. Is it possible to find the nearest numerical
field and its contents with a full text search in SQL Server 2005?

If not, I would be happy if someone could point me in the right direction.

Regards

Tore

Reply to this Message

Hilary Cotter - 20 Aug 2008 02:15 GMT

No, what you would need to do is search on Total Amount (for example) and
then client side extract the value for Total Amount. SQL FTS does not do
what you are looking for. In SQL 2008 you can use a DMV to get some of the
functionality you are looking for.

Hilary

>I am a novice on Full text search, never used it before.
> I have a large number of word documents (.doc files) with different
[quoted text clipped - 11 lines]
>
> Tore

Reply to this Message

Tore - 20 Aug 2008 22:09 GMT

Thanks.
I have read a little more on the subject and I agree.

Regards

Tore

Reply to this Message