Отменен

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

Квалификация: Excel, Visual Basic, Visual Basic для приложений

Показать больше 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

О работодателе:
( 196 отзыв(-а, -ов) ) Oconomowoc, United States

ID проекта: #23940437

Поручен:

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 Больше

$30 USD за 3 дней(-я)
(4 отзывов(-а))
1.9

17 фрилансеров(-а) в среднем готовы выполнить эту работу за $22

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 Больше

$20 USD за 1 день
(8 отзывов(-а))
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 дней(-я)
(3 отзывов(-а))
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 день
(3 отзывов(-а))
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 Больше

$20 USD за 1 день
(0 отзывов(-а))
0.0
noobydrx

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

$20 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
ibrahimbahloul07

ok i can do it

$10 USD за 2 дней(-я)
(0 отзывов(-а))
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 Больше

$10 USD за 1 день
(0 отзывов(-а))
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 Больше

$20 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
$25 USD за 1 день
(0 отзывов(-а))
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 Больше

$17 USD за 1 день
(0 отзывов(-а))
0.0
sanjusalooni7

I am Very honest person.

$25 USD за 1 день
(0 отзывов(-а))
0.0
$25 USD за 1 день
(0 отзывов(-а))
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 дней(-я)
(0 отзывов(-а))
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 день
(0 отзывов(-а))
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 день
(0 отзывов(-а))
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 дней(-я)
(0 отзывов(-а))
0.0