Re: Re: Comparing array contents to DB contents

Hmm, might be an idea..
I'm using it because I'm trying to clean up the data as I go.. theres quite a big possibility of similar names being written differently/mistyped (eg 'MudOS', 'MudOD', 'Mudos' are probably all the same thing.)

Though I've not figured out yet how tolerant it is, this is just playing around at the mo..

Comment on Re: Re: Comparing array contents to DB contents

Replies are listed 'Best First'.
Re: Re: Re: Comparing array contents to DB contents by CountZero (Bishop) on Jan 30, 2003 at 15:58 UTC
If it is just a matter of UPPERCASE v. lowercase, you can force both strings to lowercase and then do the comparison. Did you already have a look at Array::Compare? Incidentally, the simple compare method also uses "my" concatenation trick. Having had a quick peek at String::Approx I think it can be used with this concatenation trick: rather than test on eq you test on adist or adistr and see if both strings are sufficiently equal to be accepted as such or must be checked further. String::Similarity might also be a good candidate: it seems simpler than String::Approx. CountZero "If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law	[reply]

Replies are listed 'Best First'.

Re: Re: Re: Comparing array contents to DB contents
by CountZero (Bishop) on Jan 30, 2003 at 15:58 UTC

If it is just a matter of UPPERCASE v. lowercase, you can force both strings to lowercase and then do the comparison.

Did you already have a look at Array::Compare? Incidentally, the simple compare method also uses "my" concatenation trick.

Having had a quick peek at String::Approx I think it can be used with this concatenation trick: rather than test on eq you test on adist or adistr and see if both strings are sufficiently equal to be accepted as such or must be checked further.

String::Similarity might also be a good candidate: it seems simpler than String::Approx.

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law

[reply]