Re: [libreoffice-users] Match Items from two different matrix

At 08:52 16/11/2015 -0600, Jorge Rodríguez wrote:
> I understand now what you are saying

I don't think you do - at least, not entirely. 
You haven't clarified the answers to various 
questions. I don't need the answers to these - but you do!

> - I need to find which games of the first Matrix 
> appear in the second Matrix finding equal string 
> or equal word into the string. For example:
> Column-Row A1  Column-Row A6
> 0 A.D.        0 A.D. Empires Ascendant
> The content of A1 and the content of the A6 are 
> about the same game but they uses different name 
> (One single and the other complete) I need to 
> find A1 for A6 in Column B6 of Second Matrix by 
> the key in this case "0 A.D." that appear in 
> both names. Sometimes, both, the name of the 
> game of the First Matrix and the name of the 
> second Matrix are equals. I try to do this by 
> formula unknowing the exactly key but knowing that there is.

You do not know what exactly the key is, but you 
are expecting a formula in Calc to guess this for 
you. Surely that is worse than expecting it to 
read your mind, since even your mind does not know the answer, you say?

Before you can do anything like this, you do need 
to have a clear statement of exactly what 
constitutes a match and what doesn't. If you had 
"Whatever" in one column and "Whatever 2" in the 
other, would these be the same game or would one 
be the successor to the other? If one column 
included "0 A.D." and the other "0 A. D.", would 
those be the same? What about "0 A.D." and "0 
AD"? You probably cannot rely on names assembled 
from different sources being entered identically.

It may well be, of course, that it will be more 
or less impossible to define exactly what 
constitutes a match. In that case - and 
especially if the lists are not particularly 
large and you are doing this process once, not 
regularly - you may find that manual inspection 
is your quickest route. You could start by 
looking for exact matches (as explained 
previously). How about then sorting the lists 
alphabetically and picking out obvious matches? 
You could then transfer these items or rows into 
a new list. This would bring any further matches 
closer together and enable you to identify more. 
Even if you could come up with a clear criterion 
for a match, you would inevitably have to do a 
lot of manual checking afterwards to eliminate 
false positives and to add missed matches.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted