Peruttu

Excels macro to clean company name and extract info

Implement excel functions to clean a company name and extract information from a company name. Functions are simple. The logic will use lists of keywords we provide

Conversion includes

General format

-Collapse initials

-Remove punctuation

-Remove leading, trailing and extra spaces

Suffixes

-Remove unless without suffix, company is only 1 word. We will provide a list of suffixes that is expected to be added to. (example: inc, llc, corp, group, systems). Final list will be hundreds long to plan code efficiency for it

NoteWords

-Remove NoteWords: NotesWords are text that appears after key words. Example: Skype (acquired by Microsoft). “acquired by” is a key word. “Acquired by Microsoft” would be removed. The list of key words list will be hundreds long to plan code efficiency for it. (formerly, acquired by, division of, etc)

Locations

-We have a list of locations, that should be removed from the company name. Location should be removed if in parenthesis or following a delimiter (example: Fun Systems - Los Angeles would be “Fun Systems”. The list of location will be thousands long so plan code efficiency for it.

Acronym

-Compare words in company name and remove acronym. There will be a list of “skip” words that are not considered part of Acronym (of, the, a, for, etc). Example: "National Association of Developers (NAD)" would become "National Association of Developers"

The Main Function will be called CompanyCommon()

In addition, we need functions that can extract the above information using the same code base.

GetNoteWord()

GetLocation()

GetAcronym()

See screenshot for before/after examples. We will provide lists of Suffixes, NoteWords, and Locations to the winning bidder.

To show us that you have GREAT attention to detail and that you read this posting. Put the name of your favorite animal as the first word in your bid

When this is done, we want to convert the functions to also use in Google sheets, let us know if you can also do that.

Good luck

Taidot: Excel, Visual Basic, Visual Basic for Apps

Näytä lisää: visual basic extract info website, extract info yellow pages, macro design company, excel data cleaning tools, excel data cleaning tutorial, how to clean raw data in excel, macro to clean up data in excel, automated data cleaning excel, how to clean data in excel 2016, how to check and clean data in excel, data cleaning in excel pdf, extract info online sites, php extract info web page, macro extract info html page free, extract info pdf, vbnet extract info website, extract info html, macro extract info web, extract info web, extract info outlook email using

Tietoa työnantajasta:
( 196 arvostelua ) Oconomowoc, United States

Projektin tunnus: #23940437

Myönnetty käyttäjälle:

viveksr

TIGER. Hi, I have read through the details and I am interested in this project.I have already done many data conversation and data clean up projects. I assure you that I will be able to deliver you the code which meet Lisää

$30 USD 3 päivässä
(4 Arvostelua)
1.9

17 freelanceria on tarjonnut keskimäärin 22$ tähän työhön

w4po

*DOG*, ⭐ Hello, Donato⭐ I can do this easily, I'll automate this job, Cost is $20 in Less than 1 day (maybe ~7 hours), I'll use C#.NET and build a windows desktop application for you, I'll use regular expression (Rege Lisää

$20 USD 1 päivässä
(8 arvostelua)
3.8
VbaStudio

Dog. I'm an expert in Excel and VBA macros. I can do everything you need. I had done similar things before.

$30 USD 5 päivässä
(3 arvostelua)
3.2
maurineted5

I have read the instructions and the question. I am well conversant with the field and I believe I can offer a high quality paper on this assignment delivered on time.

$55 USD 1 päivässä
(3 arvostelua)
2.7
Maher4215

I can work on your terms I have 15 years experience in data entry and my typing speed is 75 WPM i have good knowledge in ms word and ms excel, i can work manually and submit the work on time with accuracy kindly contac Lisää

$20 USD 1 päivässä
(0 arvostelua)
0.0
noobydrx

.......... . .. .. . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . .. .. . . . . . .. . ...................

$20 USD 2 päivässä
(0 arvostelua)
0.0
ibrahimbahloul07

ok i can do it

$10 USD 2 päivässä
(0 arvostelua)
0.0
ZeeshanNawab092

Hi sir, I am here and I am ready to do your work with 100% [login to view URL] have a team and work from last 4 years and do same type of works.I will give you the best [login to view URL] send me a text for further discastions Lisää

$10 USD 1 päivässä
(0 arvostelua)
0.0
akanshaj1706

Dear Sir, I completely understand your work & I’m sure that I am fully capable of doing this. I have required skills for your project . please give me the opportunity to do your project.. i shall assure you that I wil Lisää

$20 USD 2 päivässä
(0 arvostelua)
0.0
$25 USD 1 päivässä
(0 arvostelua)
0.0
nadimtanvir20

dear hiring manager, at first take my sincere respect. i have gone through your project [login to view URL] see your project description, i think it’s the best choice of me,the project is will complete as soon [login to view URL] i Lisää

$17 USD 1 päivässä
(0 arvostelua)
0.0
sanjusalooni7

I am Very honest person.

$25 USD 1 päivässä
(0 arvostelua)
0.0
$25 USD 1 päivässä
(0 arvostelua)
0.0
willsbaba

Dog. I would be excited to take on this project. With experience with VB and Excel, I am certain I would complete this project timely. Also, I can convert this to be used on Google Sheet.

$20 USD 2 päivässä
(0 arvostelua)
0.0
hifzurrehman483

I will give you a complete work as you [login to view URL] also convert the functions in google [login to view URL] me.I am a hard working poor man.I need money.

$18 USD 1 päivässä
(0 arvostelua)
0.0
shubhamsharma465

My self Shubham Sharma and I am Twenty Two years old.I have One Year Deploma In Multilingual Computer [login to view URL] hobbies is Reading Books, Playing Cricket,Cooking Food, Driving car or bikes.

$25 USD 1 päivässä
(0 arvostelua)
0.0
Varshapotan02

I'm Excell expert please give me a chance to work with you ... just discuss with me about your job ...

$10 USD 5 päivässä
(0 arvostelua)
0.0