How To Search Text In A Word Document ?

Nov 24, 2005

I'm designing a Job Recruitment Website, in which the admin person searches for the right candidate for the job using certain keywords . Each jobseeker will be uploading  his CV (ms word doc) during registration .How can i search for keywords in  the word documents. I just want the candidate reference once i found keyword match in the word docs.I heard about the indexing and blobs in sql server? But dont know much about it Are these the only solutions ?Is there any better approach for this ?Any help will be greatly appreciated

View 4 Replies


ADVERTISEMENT

Search Within Word Document

Mar 2, 2007

Hi ,I would like to whether its possible or not.I have stored word document(Resume) in SQL server. Now i want to search for particular key word.for example . I want to list down all details of candidate which have ASP.Net mentioned in their resume. So please provide me any link / or article .     

View 1 Replies View Related

How Can I Search Throught DOCX (MS Word 2007) Documents By SQL Server 2005 Full Text Search Engine?

Dec 11, 2006

How can I search throught DOCX (MS Word 2007) documents by SQL Server 2005 Full Text Search engine?

Should I something download?

View 6 Replies View Related

Full Text Indexing :: Document Similarity Search

Jan 28, 2008

Hi

I have a Full Text index on a table with an image field that is successfully indexing .doc, .pdf and .rtf files.

Keyword searching this is no problem.

What i want to be able to do is perform a similarity search. by this i mean pass in a Key_ID (documentID) and have the database return a list of Key_IDs (documents) which are similar.

By similar i mean contain mostly the same keywords in roughly the same quantities

Thanks

View 3 Replies View Related

Find Exact Word In Full-Text Search

Oct 3, 2007

Hi,
I have the fields like this.

Session1               Session2                  Session3   Session4----------------------------------------------------------------------------------------- SQL Server-Part1    SQL Server-Part2      ASP.Net    CSS
C#                         SQL Server-Part3    ASP.Net    Javascript 
I have set the Full-Text to all the columns. For searching i wrote the below query
SELECT * FROM <TABLE NAME> WHERE CONTAINS(*,'"SQL Server-Part1"') 
My Result expectation is: The  First Record should come. But the result of the query bring the two records. It see the "SQL Server" string also. I need to find the exact word. How to do it? Please answer me as soon as possible. Ganesh. 
 

View 6 Replies View Related

How To Compare Two Word Documents Using Full Text Search?

Mar 19, 2006

can we use full text search and mining algorithms to comapre two word or text documents to find out if they are similar
please help.
thaks for reading

View 3 Replies View Related

Creating A Word Document

Mar 20, 2008

We are facing an issue while creating a word document through BCP utility of MS SQL Server 2005.
Ours is the Survey application where there could be various Respondents with different languages who can receive a Questionnaire through mail. Now the requirement is to send the Questionnaire in Word Document which would look like a form having Radio buttons, check boxes and images etc. controls.
To achieve this we have written a Stored procudure in MS SQL Server 2005. In this Stored procedure, we are writing an HTML Code in formatted manner and at the end using BCP utility we create a word document in specific folder. Then we attach the document from that folder in mail using sp_sendmail of MS SQL server 2005 and send it to the Respondent of the Survey.
1> The issue we are facing here is when the Respondent receives the mail and opens the word attachment, it opens the document in designer mode where controls(Radio Button and check boxes) are not clickable. Hence Respondent is not able to fill in the document as a form. However Respondent has to click on 'Exit Designer' button in the menu to make it as interactive form. The requirement is when Respondent opens the Word document it should directly open as Interactive form rather that clicking on 'Exit Desinger' button on menu.
2> Secondly when we create a word document, there are some images that need to be shown as seen below. As of now, in HTML code we have given a path of the Web Server as '<http:WebServerIP/images'. However we would like to know whether there is any way to Embed the images directly in the Word Document rather than referancing them from the Web server path.

View 2 Replies View Related

Saving A WORD Document...

Oct 23, 2003

I am trying to save an MS WORD document... What Data type should I use?

I know in Sybase we used BLOB...

View 1 Replies View Related

Printing A Word Document From T SQL

Jul 23, 2005

hi i was trying to print a word document from a stored prcedure usingthe following two methods1)cd C:&&"C:Program FilesMicrosoft OfficeOFFICE11winword.exe""c: emp.doc" /mfileprint"/mfileprint" - this macro contains the code to print the word documentand exit the word , this command runs fine when i run it at the commandprompt but when running from query analyzer i can see the job in theprinter queue but it will never finish and i need to kill the wordmanually to stop the query analyzer to finish.2)declare @hr int, @object intExec @hr = sp_OACreate 'Word.Application', @Object OUTPUTexecute sp_OAMethod @Object, 'PrintOut' ,@filename:='C: emp.doc'etc........Thank you

View 2 Replies View Related

Adding A Word Document To A Sql Db

Aug 5, 2006

I have a form that has a Word object. I want to save that object to the sql db. The original front and backend was an Access db and this all worked using an ole field. The backend data has been moved to a sql 2000 db. The reading of original Word objects works fine but I can't get any new objects stored. I have seen postings that there is no way to by-pass saving the object to a temp file but really I can't get anything to work. The attached code makes no complaints but when I try to access the new object I either get an empty object or an error that the ole server has a problem.

The code below includes simply saving an exisiting doc but that doc does not come back out of the db. I tried just for grins to store the form object in a temporary Access table and then save that field. Actually I got no complaints but then I got the same results. The use of the external file mimics examples I've seen even on this forum. any suggestions are appreciated.

Rick



'Now save word doc that is contained in the form entity
If Not IsNull(Me.oleSubSectionDetail) Then
Dim rst As ADODB.Recordset
Dim mstream As ADODB.Stream

'Tried to make it happen by essentially moving
'a database field to a db field
Dim oleRst As DAO.Recordset
Set oleRst = CurrentDb.OpenRecordset("tmpOLE", dbOpenDynaset)
oleRst.AddNew
'tempole is an ole defined field
oleRst!tempole = Me.oleSubSectionDetail
oleRst.Update
oleRst.MoveFirst

'Select record I want to update
Set rst = New ADODB.Recordset
rst.Open "Select * FROM [tbl-SOW Detail] WHERE RecID = " & RecID, ADOConnection.SQLDB_Connect, adOpenKeyset, adLockOptimistic

Set mstream = New ADODB.Stream
mstream.Type = adTypeBinary
mstream.Open

mstream.LoadFromFile "c:\Documents and Settings
burgeMy DocumentsStandard Contracts-Cover Page.doc"

'or

'mstream.Write oleRst!tempole

rst.Fields("SubsectionDetail").Value = mstream.Read
rst.Update

rst.Close
Set rst = Nothing
Set mstream = Nothing
End If

View 2 Replies View Related

Word Document Import

May 11, 2007

I need to import a word document as an RDL,
as this would save a lot of typing and formatting.

Could you advise if there is a tool available to assist with this.


Thanks


JohnJames

View 2 Replies View Related

Can RS Export Word Document?

Jun 21, 2007

I saw on the report server web page, the word format is not supported for exporting. Is there any way to export report to a word editable document.

View 1 Replies View Related

Saving Word Document To Database

Jan 3, 2005

i need to know how can i store my word document into Sql server Database
what data type ?
how can i implenet this using ASP.net

View 3 Replies View Related

Importing Word Document Into Sqlserver

Sep 1, 2004

chapter1
Delegates officially are to nominate Cheney as the GOP's vice presidential candidate before he addresses the group Wednesday night.
chapter2
"I think that the vice president's speech tonight is going to be about big issues, the big issues of this campaign -- the war on global terror, the president's education policy, the fact that the economy is turning up again," she told CNN's "American Morning."
chapter3
She said she had known her husband since he was 14 and planned to share anecdotes that many people have not heard before in her introduction.
Chapter4
Maverick Democratic Sen. Zell Miller of Georgia is scheduled to deliver Wednesday's keynote address -- a role he also played at the 1992 Democratic National Convention, which nominated President Clinton.
Chapter5
In the earlier speech, Miller, then governor of Georgia, said that "for 12 dark years, the Republicans have dealt in cynicism and skepticism. They have mastered the art of division and diversion, and they have robbed us of our hope."

I wanted to import the above word doc into my sql server DB.
I have two columns in the table
1.Chaptereid
2.chapter_notes
chater1,chater2,chapte2,chapter3,chapter4 and chapter5 should go into chaptered column and the text followed by the chapter id should be imported into chapter_notes column.

So how can I import this document.

Thanks.

View 2 Replies View Related

Insert A Word Document Into SQL Server

Sep 30, 2006

Can any tell me how to simpley insert a MS word document into an SQL Server database with a field type of image.

View 3 Replies View Related

Create Word Document From Rdl-file

May 9, 2007

Hi everybody,

I'm looking for a tool or template that creates a good looking document from the rdl-files.

I need it for internal documentation.



Can you help me?



Gerd

View 1 Replies View Related

Is There Any Word Document Destination In Ssis

Nov 28, 2007

Hi,

I have a doubt regarding SSIS data destinations. I have a word document which is stored in the sql database table as varbinary(max). I want to fetch that doument and load it into word document through ssis.Is it possible?If so,how to do it?

One more question regarding data destination..I have created an interface to execute the ssis package from asp.net application.The package will be run by sql server agent.The question is is there any way that the package output will be shown on the local machine rather than host machine(which has interface and package).

Thanks..
Have a gr8 day.

View 7 Replies View Related

How To Save Word Document In Sql Database?

Dec 27, 2007


Hi all,
I have created a word document in my application (.Net). How can I save the word document (containing tables and some HTML formats) in a database and retrieve it for later use?
Thank you in advance,

View 6 Replies View Related

Extracting Out The Rdl (layout Info) From Given Pdf/word Document

Dec 20, 2007



Hi everyone,

Is it possible to extract rdl template from a given pdf or word document? We are specifically interested in extracting layout information. We want to do it programatically.

The content and layout of pdf or word document are simple.

View 3 Replies View Related

Sql Search Command Word By Word?

Mar 30, 2005

hi!
I'm just wondering does anyone know how to create an sql command that can search word by word?
what i mean is like I have a product with name 'harry potter broom'.
I want an sql command where if i type only 'harry broom' this 'harry potter broom' product will show up.
Does anyone have any idea?
Here's my sql comand: (I'm using asp.net vb script do develop this system)
-------------------------------------------------------------------------
query = "select distinct * from product where " & _
"(pname like '%" & keyword & "%' or " & _
"pdesc like '%" & keyword & "%' ) and " & _
"(price >= " & price1 & " and price <= " & price2 & _
") and status <> 'out of stock' order by price asc"
-------------------------------------------------------------------------
Thank you.

View 4 Replies View Related

Embed A Word Document Into A Reporting Service Report

Nov 19, 2007

I've created a report that will print on a pre-printed paper. Is there a way to embed a word document into a report or some other type on document. I'm not able to format the text like in word.

View 1 Replies View Related

Integration Services :: Importing Data From Word Document (Table Format)?

Aug 4, 2015

how to import data from word document into sql server table in SSIS.

View 18 Replies View Related

Reporting Services :: SSRS 2008 - Export As Read-Only Word Document

Nov 17, 2015

I have a request from the customer to export a report to Word as a read-only document. I am restricted to out-of-the-box SSRS 2008, so I cannot write any custom export functionality.

The customer has the ability to export as PDF, and I suggested that, but before I tell them there's no easy solution, I wanted to get input from other Reporting Services folks.

View 3 Replies View Related

How To Search A Database For A Key Word Based Search?

Mar 1, 2007

Can anyone tell me how to search an SQL database for a given key word in a textbox? I basically have a database that has a qualifications column and this column needs to be searched for the data given in the textbox. Which is the best method to search for the data? Is it a simple SQL query or an XML based search engine type? Can anyone give any suggestions regarding this? If XML is efficient then how do I use it to query my database, as I'm pretty new in XML based searching.Thanks 

View 5 Replies View Related

Document Search For CMS

Dec 28, 2006

I have a database which stores documents (e.g. policies and guidelines)in our content management system. The follow relationships exist:Documents (1-to-Many) LinkTableKeywordLink (Many-to-1) KeywordsDocuments (1-to-Many) LinkTableAttachments (Many-to-1) AttachmentsDocuments (1-to-Many) LookUpSubjectsDocuments (1-to-Many) LookUpDocTypeWhen the user conducts a search I want the SQL to check if the stringthey enter is present in:* the Title, Author, Summary fields of Documents OR* the Title or Path of the Attachments* the Keywords that are links OR* the Subject that is linked OR* the DocType that is linked.Is this possible in one SQL query. I have tried the following:SELECT DISTINCT Documents.Document, Documents.Title,PriorityFROM Documents,Attachments,Keywords,LinkTableAttachments,LinkTabl eKeywordLinkWHERE((Documents.Document=LinkTableAttachments.Document ID andLinkTableAttachments.AttachmentID=Attachments.Id) OR(Documents.Document=LinkTableKeywordLink.DocumentI D andLinkTableKeywordLink.KeywordID=Keywords.Id))AND (Documents.Title Like '%SEARCHSTRING%' OR Documents.Author Like'%SEARCHSTRING%' OR Documents.Summary Like '%SEARCHSTRING%' ORKeywords.Keyword Like '%SEARCHSTRING%' OR DocType.DocType Like'%SEARCHSTRING%' OR Attachments.AttachmentTitle Like '%SEARCHSTRING%'OR Attachments.Path like '%SEARCHSTRING%' or Subjects.Subject Like'%SEARCHSTRING%')AND StartDate<=getDate() and ReviewDate>getDate() order by Titlebut this causes, perhaps understandably, a timeout error.Any thoughts?Thanks!Steve

View 4 Replies View Related

How To Do A Word Search?

Dec 29, 2006

I need to be able to search article in several tables in a MSSQL DB. What is the best way to do a word search? Are there and freebies out there or code examples?
 
Dave

View 3 Replies View Related

Search A Word In Database

Nov 24, 2006

Hi I was wondering if anyone can help me out here. I want to search a word in the database which has more than 80 tables is it possible to search all the tables at once for that word.

I am using SQL2005.

Thanks in advance.

View 2 Replies View Related

Search A Word In A Table

Mar 15, 2007

hi guys....how do i search a word in a table using MS Access query? it should search all the columns in the table. thanks.

Regards,
Rohit

View 4 Replies View Related

Multi Word Search

Oct 1, 2007

Hi,

I am trying to search a multi words with “like� function using the following statement in a S.P.:
@ITEM_desc nvarchar(10),
@QUOTFIL nvarchar (200),
@mfil nvarchar (500) = ''

SET @mfil = QUOTENAME('%' + @ITEM_desc + '%','''')
exec ('select * from ims.item where adesc like' + @mfil + @QUOTFIL)
Nrormaly one word can be send to SP for searching, is there any way to send multi word for the like function to search Like follows:

'%LOCAL%,%LIGHTS%'

Best regards

View 3 Replies View Related

Word Search In String

Feb 25, 2008



Hi All,

Please help, it is urgent

I am having a colume as image datatype, in which candidates resume is stored in binary format.
I have to search for particular words for eg. "ASP.Net, 2 Years" into that column
I have converted that column as varchar and then searching above two words(after spliting them by comma) into that string using CHARINDEX


DECLARE @i int, @j int
SET @i = select MIN(ResumeId) from table_name
SET @j = select MAX(ResumeId) from table_name

WHILE (@i <= @j)
BEGIN
DECLARE @Resume varchar(max)
SET @Resume = CAST((select Resume from table_name where ResumeId=100) as varbinary(max))

--code to search the particular word from @Resume

END

It is working fine, but it is very slow, taking 2+ minutes to scan 15000 records
How can I make it faster or is there any other way to search?

Thanks in advance


View 7 Replies View Related

ZZZZ New Text 1/1 New Text Document.txt (0/1) 18

Jul 23, 2005

Wooo hoooo!!!!1

View 2 Replies View Related

Criteria; Search Any Word In Field

May 26, 2004

I am trying to set up a query that will allow the user to input a string, and the search will match ANY word in that string. Currently, I have it configured so that the search will only match the exact string that the user inputs. I have google searched for the answer, but no luck yet. Any ideas?

View 9 Replies View Related

Can I Search A Word Only In My All Stored Procedure

May 5, 2008

hi
can i search a word in my all stored procedure
not in system stored procedure
only in my stored procedure

like i need to search ' Getdate() ' in my all stored procedure

TNX

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved