473,880 Members | 1,716 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Search keyword from string of data (Please help!)

I have a main table with a text description field. In this field, its
populated with a string of data. I need to identify from this string
of data the name of the vendor using some keywords.

I have another table that contains 2 fields, one being the keywords to
search for from the string of data and the other field being the
vendor name to pair up with the record.

How do I reference the keywords from the 2nd table and search thru the
string of data from the text description field from the main table and
then apply the vendor name to the main table?

Please help.

Oct 18 '07 #1
5 3386
On Oct 18, 5:51 pm, kan...@rocketma il.com wrote:
I have a main table with a text description field. In this field, its
populated with a string of data. I need to identify from this string
of data the name of the vendor using some keywords.

I have another table that contains 2 fields, one being the keywords to
search for from the string of data and the other field being the
vendor name to pair up with the record.

How do I reference the keywords from the 2nd table and search thru the
string of data from the text description field from the main table and
then apply the vendor name to the main table?

Please help.
You can create a query containing both tables. Set the criteria for
the [main table].[text description] to LIKE "*" & [another table].
[keyword] & "*"

Note that you really should have each keyword on a separate row of the
table, to select with an or condition. Two keywords in the same row
means that the query will only match if the exact phrase is found,
with the same sequence. You van insert an asterisk to allow variations
in spacing, punctuation and intermediary words.

Keyword finds
John Mary John Mary
John*Mary John, Mary
John*Mary John Smith or Mary Christmas
--
Bob Quintal
Oct 18 '07 #2
On Oct 18, 4:01 pm, "rquin...@sympa tico.ca" <bob.quin...@gm ail.com>
wrote:
On Oct 18, 5:51 pm, kan...@rocketma il.com wrote:
I have a main table with a text description field. In this field, its
populated with a string of data. I need to identify from this string
of data the name of the vendor using some keywords.
I have another table that contains 2 fields, one being the keywords to
search for from the string of data and the other field being the
vendor name to pair up with the record.
How do I reference the keywords from the 2nd table and search thru the
string of data from the text description field from the main table and
then apply the vendor name to the main table?
Please help.

You can create a query containing both tables. Set the criteria for
the [main table].[text description] to LIKE "*" & [another table].
[keyword] & "*"

Note that you really should have each keyword on a separate row of the
table, to select with an or condition. Two keywords in the same row
means that the query will only match if the exact phrase is found,
with the same sequence. You van insert an asterisk to allow variations
in spacing, punctuation and intermediary words.

Keyword finds
John Mary John Mary
John*Mary John, Mary
John*Mary John Smith or Mary Christmas

--
Bob Quintal
I guess I was not clear enough, let me give an example.

So below are the two tables I have. In Table 1, I have a text
description field. I need to search from the text description field
to determine who the vendor is. Therefore, in table 2, I have a list
of keyword that I can identify the vendor with by searching through
the text field in table 1.

How do I identify the vendor using table 2 and then populate table 1
with the vendor name reference in table 2?

Table 1

Text Description Transaction amount Vendor
2323a2007 ABC Bank $10
ABCVISA Bank $20
DataABC $30
Sep 07 ABC Bank $20
CDE Bank $30
Aug 07 ABC Bank $50
Bank of EFG $20
EFG transaction adj $10

Table 2

Keyword Vendor
ABC ABC Bank
CDE CDE Bank
EFG Bank of EFG

Oct 18 '07 #3
On Oct 18, 7:38 pm, kan...@rocketma il.com wrote:
On Oct 18, 4:01 pm, "rquin...@sympa tico.ca" <bob.quin...@gm ail.com>
wrote:
On Oct 18, 5:51 pm, kan...@rocketma il.com wrote:
I have a main table with a text description field. In this field, its
populated with a string of data. I need to identify from this string
of data the name of the vendor using some keywords.
I have another table that contains 2 fields, one being the keywords to
search for from the string of data and the other field being the
vendor name to pair up with the record.
How do I reference the keywords from the 2nd table and search thru the
string of data from the text description field from the main table and
then apply the vendor name to the main table?
Please help.
You can create a query containing both tables. Set the criteria for
the [main table].[text description] to LIKE "*" & [another table].
[keyword] & "*"
Note that you really should have each keyword on a separate row of the
table, to select with an or condition. Two keywords in the same row
means that the query will only match if the exact phrase is found,
with the same sequence. You van insert an asterisk to allow variations
in spacing, punctuation and intermediary words.
Keyword finds
John Mary John Mary
John*Mary John, Mary
John*Mary John Smith or Mary Christmas
--
Bob Quintal

I guess I was not clear enough, let me give an example.

So below are the two tables I have. In Table 1, I have a text
description field. I need to search from the text description field
to determine who the vendor is. Therefore, in table 2, I have a list
of keyword that I can identify the vendor with by searching through
the text field in table 1.

How do I identify the vendor using table 2 and then populate table 1
with the vendor name reference in table 2?

Table 1

Text Description Transaction amount Vendor
2323a2007 ABC Bank $10
ABCVISA Bank $20
DataABC $30
Sep 07 ABC Bank $20
CDE Bank $30
Aug 07 ABC Bank $50
Bank of EFG $20
EFG transaction adj $10

Table 2

Keyword Vendor
ABC ABC Bank
CDE CDE Bank
EFG Bank of EFG
You were clear enough, except that you said "one being the keywords to
search for from the string of data and the other field being the
vendor name" Had you not pluralized "keywords" I would have not added
the cautionary note about one keyword per row, since that is what you
have.

You build a query as I detailed above. put the two tables into the
query. In the grid section, bring down the vendor from table 2. bring
down the Text Description from table 1 In the criteria row, under the
text description column, put LIKE "*" & [keyword] & "*"

Run the query. When you test it works in a view, convert the query to
an update query to set the table 1 vendor with the table 2 vendor.

Oct 19 '07 #4
ka****@rocketma il.com wrote in
news:11******** **************@ q5g2000prf.goog legroups.com:
I have a main table with a text description field. In this field,
its populated with a string of data. I need to identify from this
string of data the name of the vendor using some keywords.

I have another table that contains 2 fields, one being the
keywords to search for from the string of data and the other field
being the vendor name to pair up with the record.

How do I reference the keywords from the 2nd table and search thru
the string of data from the text description field from the main
table and then apply the vendor name to the main table?

Please help.
You can create a query containing both tables. Set the criteria for
the [main table].[text description] to LIKE "*" & [another table].
[keyword] & "*"

Note that you really should have each keyword on a separate row of
the table, to select with an or condition. Two keywords in the same
row means that the query will only match if the exact phrase is
found, with the same sequence. You van insert an asterisk to allow
variations in spacing, punctuation and intermediary words.

Keyword finds
John Mary John Mary
John*Mary John, Mary
John*Mary John Smith or Mary Christmas
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Oct 19 '07 #5
ka****@rocketma il.com wrote in
news:11******** **************@ i13g2000prf.goo glegroups.com:
On Oct 18, 4:01 pm, "rquin...@sympa tico.ca"
<bob.quin...@gm ail.comwrote:
>On Oct 18, 5:51 pm, kan...@rocketma il.com wrote:
I have a main table with a text description field. In this
field, its populated with a string of data. I need to identify
from this string of data the name of the vendor using some
keywords.
I have another table that contains 2 fields, one being the
keywords to search for from the string of data and the other
field being the vendor name to pair up with the record.
How do I reference the keywords from the 2nd table and search
thru the string of data from the text description field from
the main table and then apply the vendor name to the main
table?
Please help.

You can create a query containing both tables. Set the criteria
for the [main table].[text description] to LIKE "*" & [another
table]. [keyword] & "*"

Note that you really should have each keyword on a separate row
of the table, to select with an or condition. Two keywords in the
same row means that the query will only match if the exact phrase
is found, with the same sequence. You van insert an asterisk to
allow variations in spacing, punctuation and intermediary words.

Keyword finds
John Mary John Mary
John*Mary John, Mary
John*Mary John Smith or Mary Christmas

--
Bob Quintal

I guess I was not clear enough, let me give an example.

So below are the two tables I have. In Table 1, I have a text
description field. I need to search from the text description
field to determine who the vendor is. Therefore, in table 2, I
have a list of keyword that I can identify the vendor with by
searching through the text field in table 1.

How do I identify the vendor using table 2 and then populate table
1 with the vendor name reference in table 2?

Table 1

Text Description Transaction amount Vendor
2323a2007 ABC Bank $10
ABCVISA Bank $20
DataABC $30
Sep 07 ABC Bank $20
CDE Bank $30
Aug 07 ABC Bank $50
Bank of EFG $20
EFG transaction adj $10

Table 2

Keyword Vendor
ABC ABC Bank
CDE CDE Bank
EFG Bank of EFG

You were clear enough, except that you said "one being the
keywords to search for from the string of data and the other
field being the vendor name" Had you not pluralized "keywords" I
would have not added the cautionary note about one keyword per row,
since that is what you have.

You build a query as I detailed above. put the two tables into the
query. In the grid section, bring down the vendor from table 2.
bring down the Text Description from table 1 In the criteria row,
under the text description column, put LIKE "*" & keyword & "*"
Run the query. When you test it works in a view, convert the query
to an update query to set the table 1 vendor with the table 2
vendor.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Oct 22 '07 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
4352
by: Duncan Winn | last post by:
I am new to VC++7. I am using a method GetPrivateProfileString that requires an LPTSTR. I have defined this as a: char * data_name; I am then trying to convert this to an LPOLESTR and I have done this as follows: LPOLESTR dunk_data = (LPOLESTR)T2CW(data_name);
10
1056
by: Tiraman :-\) | last post by:
hi, i have a little problem to concat a string with some "," sign. this is my code: Dim mystring as string = "" for i=1 to 3 mystring = mystring & "," & otherstring next i
9
1584
by: Tris | last post by:
Hi People I need help!!! Have got a excel file that i have put into an access file so that i can create a mailing carrier sheet without re typing everybodys details in. The excel file has some blank spaces within it for example: Mr A Smith
5
1867
by: Kosmos | last post by:
Hey :) hopefully someone can help me with this...I decided to take on the task of programming an access database for my legal co-op/internship...I'm studying law and music production on the side...most of the background I have in programming has to do with music production... The program I'm creating pulls data from an excel sheet (with defined fields) and brings them into an access database. The data being pulled is the following: ...
8
18095
by: Greg Lyles | last post by:
Hi all, I'm trying to develop an ASP.NET 2.0 website and am running into some real problems with what I thought would be a relatively simple thing to do. In a nutshell, I'm stuck on trying to display data in a "GridView" which is tied to an "ObjectDataSource". In turn, this ObjectDatasource gets it's data from a strongly-typed business object within my code.
3
5620
by: Skip | last post by:
OK, I'm a novice in JS but have lots of coding experience. I am trying to accomplish something that would seem somewhat simple - BUT IT'S NOT. I have a basic window that calls another window with window.open and passes in 1 value using a querystring i.e., www.myhome.com/mypage?video=BAK-Extension Now when the window opens, I can capture the passed value in a JS function. But if I want to use that in the body of the HTML in a
2
2793
by: palgre | last post by:
Hi ALL, I am working in an windows based application using SQL Server 2000 as database. There are few tables (refer parent tables) in the application which are uploaded by a seprate application. My application fetches data from parent tables and put data in separate tables (chils tables) of application. I am using dataset to fetch data from parent tables and insert/update data in child table.
3
1252
by: sharonrao123 | last post by:
Hello all, I have a products table (see below) Product State Apple |1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|27| I have to display the state data on a webform replacing the numbers with actual state names for example replace 1 with auckland, 2 with northland and so on. How to do this in SQL. Please help. Cheers, Shilpa.
0
9926
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9774
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11093
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10396
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7951
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7105
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5973
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4192
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3220
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.