Search for a list of keywords in a string

**vishalbht** · 03-27-2012, 02:05 AM

Hi,

I have a access database that has a table containing some keywords and those keywords are mapped to some text. I have a functionality which allows users to upload PO data to the access database. this PO data has some Item text. I want to use this Item text and compare it to the keywords table and apply the rules for the keywords where the keywords match the words in the Item text. Please let me know how can we do this

Thanks
Vishal

**CreganTur** · 03-28-2012, 07:52 AM

You can use the InStr function to locate a specific string within a string. This is one option for what you want to do.

**HiTechCoach** · 03-29-2012, 10:00 AM

You can also do it with a Query. In the Where clause use Like with wildcards.

03-27-2012, 02:05 AM	#1
vishalbht VBAX Newbie Joined: Mar 2012 Posts: 1 Kb Entries: 0 Articles: 0	Search for a list of keywords in a string Hi, I have a access database that has a table containing some keywords and those keywords are mapped to some text. I have a functionality which allows users to upload PO data to the access database. this PO data has some Item text. I want to use this Item text and compare it to the keywords table and apply the rules for the keywords where the keywords match the words in the Item text. Please let me know how can we do this Thanks Vishal
Local Time: 11:46 AM Local Date: 05-22-2013 Location:

03-28-2012, 07:52 AM	#2
CreganTur VBAX Mentor Joined: Jan 2008 Posts: 1,674 Kb Entries: 2 Articles: 1	You can use the InStr function to locate a specific string within a string. This is one option for what you want to do. -Randy Shea I'm a programmer, but I'm also pro-grammar! If your issue is resolved, please use Thread Tools to mark your thread as Solved! PODA (Professional Office Developers Association) \| Certifiable \| MOS: Access 2003
Local Time: 03:46 PM Local Date: 05-22-2013 Location:

03-29-2012, 10:00 AM	#3
HiTechCoach VBAX Regular Joined: Jul 2010 Posts: 293 Kb Entries: 0 Articles: 0	You can also do it with a Query. In the Where clause use Like with wildcards. Boyd Trimmell aka HiTechCoach Microsoft MVP - Access Expert Programming: Nine different ways to do it right, a thousand ways to do it wrong. Binary--it's as easy as 1-10-11
Local Time: 02:46 PM Local Date: 05-22-2013 Location: