D
Don McIntyre
I have a Database of 56000 Company Names, when a new record is to be added I
have to determine if the Company exists inthe current Dataset and then
manually decide if it is a new site for that company or updated information
or a genuine new entry.
So much for the problem, now the form of the data is an excel sheet and the
Company Name may be similar but not exact eg DS Smith or D S Smith
Corrugators Ltd.
I would like to step through the existing data and apply human logic to
decide an action.
If the name is similar but has a mismatch of x letters then it may be the
same company and I would then see a list of similar entries to decide the
appropriate action.
From my distant college days (30 years ago) I seen to recall fuzzy logic may
be an answer but old age has caught up and I cannot remember even the basics
of what I was taught.
Thanks in advance
have to determine if the Company exists inthe current Dataset and then
manually decide if it is a new site for that company or updated information
or a genuine new entry.
So much for the problem, now the form of the data is an excel sheet and the
Company Name may be similar but not exact eg DS Smith or D S Smith
Corrugators Ltd.
I would like to step through the existing data and apply human logic to
decide an action.
If the name is similar but has a mismatch of x letters then it may be the
same company and I would then see a list of similar entries to decide the
appropriate action.
From my distant college days (30 years ago) I seen to recall fuzzy logic may
be an answer but old age has caught up and I cannot remember even the basics
of what I was taught.
Thanks in advance