<meta http-equiv="content-type" content="text/html; charset=utf-8"><div></div><div>Very interesting Nyall </div><div><br></div><div>That makes me remember that the vlookup in excel also has a "bests match" by default. I always turn it off because it uses the first found possible match. I wonder if it uses the same type of "Fuzzy" logic...? </div><div><br></div><div>Nicolas</div><div><br>Le 4 nov. 2016 à 23:22, Nyall Dawson [via <a href="http://OSGeo.org" target="_top" rel="nofollow" link="external">OSGeo.org</a>] <<a href="/user/SendEmail.jtp?type=node&node=5294431&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>> a écrit :<br><br></div><blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' type="cite"><div>
<p dir="ltr"></p>
<p dir="ltr">On 5 Nov 2016 12:13 PM, "Joe Lertola" <<a href="/user/SendEmail.jtp?type=node&node=5294406&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>> wrote:<br>
><br>
> Hello.<br>
><br>
> Today I made a thematic map by joining a list of data that had country names to a shape file of world countries. I had to spend a lot of time working in Excel to make my data names match the names in the shape file. A lot of them already matched but there were many that didn’t. For example the the shape file had Ivory Coast and the data had Cte d’Ivoire as the name. Is there any way to do this in Qgis instead of Excel? Years ago I recall doing this in ArcMap. There was a tool that matched up the data where it could and then for each record that wasn’t matched you could choose the matching record manually. Any help would be greatly appreciated.</p>
<p dir="ltr">How good are your python skills? Sounds like a perfect candidate for a new processing algorithm. QgsStringUtils has methods for performing "fuzzy" matching of strings, so a lot of the hard work is already done.<br></p>
<p dir="ltr">Nyall</p>
<p dir="ltr">><br>
> Thanks,<br>
> -Joe<br>
><br>
><br>
> _______________________________________________<br>
> Qgis-user mailing list<br>
> <a href="/user/SendEmail.jtp?type=node&node=5294406&i=1" target="_top" rel="nofollow" link="external">[hidden email]</a><br>
> List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></p>
<br>_______________________________________________
<br>Qgis-user mailing list
<br><a href="/user/SendEmail.jtp?type=node&node=5294406&i=2" target="_top" rel="nofollow" link="external">[hidden email]</a>
<br>List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br>
<br>
<hr noshade="noshade" size="1" color="#cccccc">
<div style="color:#444; font: 12px tahoma,geneva,helvetica,arial,sans-serif;">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
<a href="http://osgeo-org.1560.x6.nabble.com/Fwd-Joining-data-to-a-shape-file-by-country-name-when-the-names-don-t-match-exactly-tp5294403p5294406.html" target="_top" rel="nofollow" link="external">http://osgeo-org.1560.x6.nabble.com/Fwd-Joining-data-to-a-shape-file-by-country-name-when-the-names-don-t-match-exactly-tp5294403p5294406.html</a>
</div>
<div style="color:#666; font: 11px tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em;line-height:1.5em">
To start a new topic under Quantum GIS - User, email <a href="/user/SendEmail.jtp?type=node&node=5294431&i=1" target="_top" rel="nofollow" link="external">[hidden email]</a> <br>
To unsubscribe from Quantum GIS - User, <a href="" target="_top" rel="nofollow" link="external">click here</a>.<br>
<a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" rel="nofollow" style="font:9px serif" target="_top" link="external">NAML</a>
</div></div></blockquote>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Fwd-Joining-data-to-a-shape-file-by-country-name-when-the-names-don-t-match-exactly-tp5294403p5294431.html">Re: Joining data to a shape file by country name when the names don't match exactly</a><br/>
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html">Quantum GIS - User mailing list archive</a> at Nabble.com.<br/>