1: Are you trying to do this once (ie run a batch job) or are you
trying to do this on the fly while an end user is waiting? If it's the
first, it might be doable, pending the answers to the other question.
If it's the second, it's going to be very, very unlikely.
2: How are you wanting to match them? Are you trying to find if the
tmp name is a substring of the company name? That's easy. Are you
trying to find out if they share a certain number of words? That can be
done. Are you trying to match "Bob's Pipe Company" with "Robert's
Piping"? That's hard to the point of "it'd be about as easy to do it
manually".
Um... and a third, while I'm at it:
"1,0000 [sic]" == 1,000
or
"1,0000 [sic]" == 10,000
?
--Ben
Kristen Winsor wrote:
> Hello All
> In one table I have the Company.companyName and another table I have the
> tmpMatchCompany.companyName I have identified the exact matches,
> however, I need to identify that if Company.companyName = ABC company,
> INc. is the match for
> tmpMatchCompany.companyName abc company
>
> Is this hopeless, there are approx 1,0000 files to match up?
>
> As always, any assistance is appreciated.
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
