Software to search for perfect match
Thread poster: sheley

sheley
Local time: 22:33
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


 

Adam Łobatiuk  Identity Verified
Poland
Local time: 22:33
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.


 


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







BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »
SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running, helps experienced users make the most of the powerful features, ensures new

More info »



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