Hi all
I have a list of about 10,000 customers in an Oracle database. An example of
the type of dat we have is as follows,
REGUS CONSULTING
REJUS CONSULTANTS
REGUS CONSULTANTS
RGS CONSULTANTS
RGS C/TANTS
REGUS CONSULTING LTD
REGUS CONSULTING LIMITED
RGS CONSULTANTS LTD
These are imaginary examples but give an example of the state of the data.
What I would like to know is if there are any modules that can find similar
matches in this data (soundex in Oracle is not quite up to the task). I was
thinking about writing a script to iterate over each customer as follows
where the bit in the brackets will be what I search other customer names
for.
(REGUS) CONSULTING
R(EGUS )CONSULTING
RE(GUS C)ONSULTING
REG(US CO)NSULTING
REGU(S CON)SULTING
REGUS( CONS)ULTING
REGUS (CONSU)LTING
REGUS C(ONSUL)TING
REGUS CO(NSULT)ING
REGUS CON(SULTI)NG
REGUS CONS(ULTIN)G
REGUS CONSU(LTING)
I will use the findings to fill an excel spreadsheet where they then just
need to put a number to indicate which customer is correct.
It seems laborious and it is limited to the length of the search string (I
have used 5 character as the search string above). Any ideas / suggestions.
Harry
*************************************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. +44 20 7390 3900
This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message. Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.
*************************************************************************************
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
