in reply to Re: CSV Cross Referencing
in thread CSV Cross Referencing

It is a nice thought, but I can see a problem with false negatives too. Suppose the lat in one set is 5000000 and in the other it's 4999998 - those are not going to be found using pattern-matching. You would have to both add and subtract the maximum error and then compare both of those outer limits to the second set. It's do-able in Perl but the RDBMS seems like the better way to me.

Replies are listed 'Best First'.
Re^3: CSV Cross Referencing
by ww (Archbishop) on Dec 03, 2014 at 13:00 UTC

    AMEN!

    At some point(s), be it as in your example, or otherwise, there are going to be edge cases that are going to require a lot of effort to resolve.

    Thanks for making an important point I missed.


    Spirit of the Monastery


[reply]
[d/l]

In Section Seekers of Perl Wisdom