Solved

check over the words

Posted on 2002-03-28
5
150 Views
Last Modified: 2010-05-02
hi everyone..

i have a little problem here..

i'm using vb and microsoft access (as the d/b) for my system.. a machine translation system

in this system, for example i have this kind of text;

The management is not answerable for any loos of personal belongings.

okay, now i have this kind of pattern that i've done to save it in the d/b, for example

The management
is not
answerable
...

at the other side, another column of my table in database, i have this kind of text

DT
NN
IN
...

you don't have to know what DT, NN , IN and so on, its out of my question

actually, DT is for 'The' and NN is for 'management'

now, how am i going to combine those 2 words according to the number of word in the text?

so that in my database will look like this

first column                    2nd column
The management                     DT_NN
....                               .....

and so on..

all i've been thinking of is by counting the number of text in the 1st row of the 1st column and the 2nd column will be put according to the number of coresponding text.

any idea?

help me please.

FaRZ
0
Comment
Question by:FaRZ
  • 2
  • 2
5 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 6905531
You may find experts more responsive if you maintain your open questions.  For the record:

Questions Asked 11
Last 10 Grades Given A A A C C B  
Question Grading Record 6 Answers Graded / 6 Answers Received

Thanks,
Anthony
0
 
LVL 22

Accepted Solution

by:
rspahitz earned 50 total points
ID: 6905597
Actually, FaRZ, this could be better handled with a normalized database structure, although it may end up being slow to retrieve if there are too many combinations.

For example, if you currently have one table, tblCodes, it may look like this:

tblCodes
----
CodeID, primary key, autonumber
CodeName, 2-character text
CodeValue, memo

Some records might look like this:
CodeID  CodeName  CodeValue
1       DT        The
2       NN        management

To create combinations of these in a set of normalized table, you'd have this:

tblWordCombos
----
WordComboID, primary key, autonumber
SentenceID, lookup to tblSentence
CodeID, lookup to tblCode

tblSentence
----
SentenceID, primary key, autonumber
SentenceInfo, memo


...
For a given sentence, you would store the link between the sentence and the codes.

In the case of "The management", you'd have these records:

tblSentence record:
SentenceID  SentenceInfo
1           (This memo field optionally describes the sentence)

tblWordCombos records:
WordComboID  SentenceID  CodeID
1            1           1
1            1           2


When you report on these, you identify the sentence you want to translate (i.e. get the SentenceID code) then use the WordCombo records to find the corresponding items, which in this case is two records with codeIDs 1 and 2.

When you use those to translate back to tblCodes, you can either pull up the DT and NN from the CodeName field, or use the CodeValue field to get "The" and "management"

--
I'm not sure if I explained it well, but it sounds like normalization might solve your problems.
0
 

Author Comment

by:FaRZ
ID: 6914816

rspahitz.. thanks for your opinion and consideration..

by now.. i've got the solution of this problem.. what you tell me is good.. but.. i've done it in different way.. but you gave me idea of doing it.. thanks so much..

well.. i would like to give  you the mark.. freely.. for your kindness to me.. thanks a lot..

FaRZ
0
 

Author Comment

by:FaRZ
ID: 6914820

thanks again
0
 
LVL 22

Expert Comment

by:rspahitz
ID: 6915546
Always glad to help!
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

773 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