Software to search for perfect match
Thread poster: sheley

sheley
Local time: 20:17
Jul 7, 2010

Hi,
I am looking for some help with finding a tool which can find perfect or part matches in excel documents that contain lists of different website urls.
Does anyone have any experience with this?
Thanks,
Sheley


Direct link Reply with quote Turn social sharing on.
Like 8
 

Adam Łobatiuk  Identity Verified
Poland
Local time: 20:17
Member (2009)
English to Polish
+ ...
Excel itself Jul 7, 2010

Hi Sheley,

It's not easy and may put you off at first, but try using Excel functions. For example, my favourite VLOOKUP returns perfect matches between 2 lists. Not sure about fuzzy matches, but there are functions for comparing left, right or middle parts of strings, which could work with your URL's. And sorting might be useful, too. And you can combine functions in formulas as well. Try reading help on them, especially examples. Functions also work in OpenOffice where they might (or not) be explained better.


Direct link Reply with quote Turn social sharing on.
Like 7
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Software to search for perfect match

Advanced search







Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »
SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search