The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
The purpose of this application is to clean a list of words and produce a normalised list.
Attached is a file called Wordlist to clean (this one is an excel spreadsheet). As you can see there are a number of words in this file. These are words that consumers have given us to describe companies. They are their words, so the data is quite dirty.
The problem is that the list is not normalised, which makes it impossible to analyse.
We want to build a tool (almost certainly as an Excel macro) that goes through the list and references it against a "normalised list". The normalised list will have a list or words in the way they are presented when typed in and then a list of normalised responses.
So ugly and uhgly would be normalised to Ugly
And Cheep and cheip would normalise to Cheap
Any words that do not match the normalised list are highlighted to the user who then enters a normalised version of the words (this pair is then added to the list of normalised words). Alternatively...
Sign in or Register to see more