Fuzzy Match

[suleman Shreef]

Hi,
Richard, there is any way to do fuzzy matched and return the full company name.
return the full company name and address
all most all row are same.

Code: Select all

CompanyRecSet:= dataset([{'HPCC system','101 Sussex Street'},
                                    {'HPCC','101 Sussex Street'},
                                    {'AET','1900 West Loop South, Suite 920'},
                                    {'AET UK LIMITED','1900 West Loop South, Suite 920'}],
                                    {varstring ComapnyName,varstring Address});

CompanyRecSet;

thanks and regard
Suleman shreef

[rtaylor]

Suleman,

Here are a couple of ways:

Code: Select all

IMPORT Std;
CompanyRecSet:= DATASET([{'HPCC system','101 Sussex Street'},
                         {'HPCC','101 Sussex Street'},
                         {'HPCC Systems Inc','101 Sussex Street'},
                         {'HPCsystems Limited','201 Sussex Street'},
                         {'AET','1900 West Loop South, Suite 920'},
                         {'AET UK LIMITED','1900 West Loop South, Suite 920'}],
                         {STRING CompanyName,STRING Address});

CompanyRecSet;
CompanyRecSet(Std.Str.StartsWith(CompanyName,'HPCC'));
CompanyRecSet(Std.Str.WildMatch(CompanyName,'*System*',TRUE));

The Standard Library Reference contains the documentation for these (and many other) string handling functions. Press F1 in the ECL IDE and you'll see that book is part of the online Help file.

BTW, you will note that I changed your VARSTRINGs to STRINGs. In HPCC, STRING is the default string type. VARSTRING is only used for data coming in or going out that has/needs actual null terminators -- internally within HPCC there is no advantage to using VARSTRING over STRING.

HTH,

Richard

[suleman Shreef]

Richard, I have done using string build in function, but based on matched score like 80 matched need to select.

[JimD]

You can also use the metaphone library support in the Standard Library to create "sounds like" fuzzy matching.

See http://cdn.hpccsystems.com/releases/CE- ... f#page=111

HTH,

Jim