2015 Archives by date, by thread · List index

# 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
```