Solved

how to loop through all the words in a document query a database to see if word or phrase exist in database

Posted on 2013-06-30
7
236 Views
Last Modified: 2014-01-11
How can I loop through all the words in a microsoFt WORD DOC AND CHECK IF THAT WORD OR A PHRASE EXISTS IN an excel database and then either replace the word with another from the database or insert a particular picture whose [ath is in the database
0
Comment
Question by:Dov_B
  • 4
  • 3
7 Comments
 
LVL 35

Accepted Solution

by:
[ fanpages ] earned 500 total points
ID: 39288562
Hi,

As I queried in a remarkably similar question from 6 June 2013:

[ http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28149909.html#a39226799 ]

Would it be feasible/practical to copy'n'paste the text from the MS-Word document into a separate worksheet within the MS-Excel workbook so that the comparison can be performed in one application?

BFN,

fp.
0
 

Author Comment

by:Dov_B
ID: 39305882
not realy
0
 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 39305892
OK.

Can you clarify what you mean by "an excel database", please?
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

Author Comment

by:Dov_B
ID: 39305893
a list of words in a column sorry for calling it a database
0
 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 39305906
:)

How is a replacement word to be determined?

I presume there are actually two columns; one of a list of words, & another adjacent with a list of paths.

Perhaps the provision of a sample file would be useful.
0
 

Author Comment

by:Dov_B
ID: 39305909
I presume there are actually two columns; one of a list of words, & another adjacent with a list of paths.
Yes
0
 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 39527413
Abandoned thread?
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question