Kapalı

Use automated program to merge text data and excel data

See Sample excel file. There are names of companies and their addresses. This is just sample. Actual file will be bigger. It goes to until column E.

Also, see the text file. It's just text file about a company.

Make a program that will add column F to the excel file. Column F will contain the text (.txt) file name that is associated with this company.

So, you need to merge excel data and text file using company names.

Remember. Not all company names exactly coincide. For example, "Corporation" can be written as "Corp" or "Co". There are many such examples. Tell me how you will handle this problem. Tell me all such examples.

When you bid, answer the following questions. Otherwise, your bid will be immediately removed.

1. Don’t be discouraged even if I hire someone before hiring you. I will hire multiple people because there are many documents. And I will pay all people I hire. Do you understand?

2. I said not all company names exactly coincide. For example, "Corporation" can be written as "Corp" or "Co". Tell me all such examples you know. I already know many examples. I am testing you.

Beceriler: C Programlama, Veri İşleme, Perl, Python, Yazılım Mimarisi

Daha fazlasını gör: data merge indesign, generate word document from excel data, how do i merge excel data into word document?, importing data from excel to word template, link data from excel to word, how to import multiple text files into one excel spreadsheet, how to merge excel data into a word document, indesign data merge multiple records, excel data entry mail merge form, use chinese text excel macro, merge excel data pdf form, java program merge text file delimiter, excel importing text file data row, merge text files file program, hoe use excel data input, merge text file excel vba, use excel data stata, excel data mapping program, use access merge text files together, merge excel data pdf

İşveren Hakkında:
( 44 değerlendirme ) Chicago, United States

Proje NO: #19252927

Bu iş için 28 freelancer ortalamada $162 teklif veriyor

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Daha Fazla

$250 USD in 3 gün içinde
(405 Değerlendirme)
7.8
asin1987

Dear Employer, As you said Cooperation can be CO or Co-op, we would need to discuss all such possibilities information of which you would need to share with me (like INC for INCORPORATED, LTD for Limited etc). So we Daha Fazla

$250 USD in 10 gün içinde
(152 Değerlendirme)
7.3
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Daha Fazla

$200 USD in 5 gün içinde
(222 Değerlendirme)
7.6
zekovicm

Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and it can be done with Excel VBA ! I can start immediately and finish it within the agreed deadline. Daha Fazla

$166 USD in 10 gün içinde
(95 Değerlendirme)
7.1
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$150 USD in 5 gün içinde
(140 Değerlendirme)
6.5
idleswell

Thanks for your project. I am the premiere Perl scripting expert on these freelancing sites. I will create a Perl script using public domain modules to process an Excel document to add a column linking to closely ma Daha Fazla

$137 USD in 10 gün içinde
(210 Değerlendirme)
6.3
dinhfreedom

-Interested Job. Pro Data Processing, Perl, Python, Software Architecture expert. Best result in time----- [login to view URL] I read your description very carefully. I am very interesting for your project because I have ri Daha Fazla

$200 USD in 10 gün içinde
(68 Değerlendirme)
6.4
brianconey

Hello How are you . I am a python expert and I am sure I can do as your requirement Best Regard . Thanks for your posting

$166 USD in 10 gün içinde
(29 Değerlendirme)
5.9
williams115

-Professional C Programming, Data Processing, Perl, Python, Software Architecture expert ! Best Result in Time!------------------------------ Hello sir. I've really rich experience for your project, so your project i Daha Fazla

$100 USD in 10 gün içinde
(34 Değerlendirme)
5.8
carlosperezit

Hola Mi nombre es Carlos y soy especialista en .Net y SQL Server Tengo mas de 20 años de experiencia en el desarrollo de Software Tengo mucha experiencia en el desarrollo de aplicaciones de escritorio y basadas en W Daha Fazla

$111 USD in 3 gün içinde
(35 Değerlendirme)
4.9
sourabhg98

Hey there :) This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer. I have checked both the files you attached. I understand the requirements of the project. To answer both your question Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(45 Değerlendirme)
5.0
susanna2018

Hi, Sir!! if you use Python, your project will be very simple and python is very powerful and very simple. 1. i understand first question. i wan to keep long -term with you. 2. i think address is al Daha Fazla

$200 USD in 10 gün içinde
(14 Değerlendirme)
4.5
sajidkhan45

Hi, I am an excel VBA expert and went through your project description, the text file and excel file. I can create a macro that does this automatically which means there would be zero manual error and the fastest me Daha Fazla

$100 USD in 3 gün içinde
(31 Değerlendirme)
4.7
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Daha Fazla

$100 USD in 3 gün içinde
(36 Değerlendirme)
4.5
vsprybhanu

Answer your questions - 1. Yes, I know you will hire multiple freelancer 2. Yes, "Corporation" can be written as "Corp" or "Co". Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I Daha Fazla

$190 USD in 10 gün içinde
(34 Değerlendirme)
4.7
sunny2309

Hello, I have good experience with Python and its libraries related to data manipulation, visualisation etc. I have good knowledge on libraries like numpy, pandas, matplotlib, and many more. I can help you implement Daha Fazla

$166 USD in 10 gün içinde
(18 Değerlendirme)
4.3
DataShu

Corporation could be written as, Corp, Corp. , CPN, Co, Co., or simply Coy and INC for incorporated. Please contact i will do this using python. Thanks.................................................

$149 USD in 7 gün içinde
(11 Değerlendirme)
3.7
christinestraub

Hello Nice to meet you. I'm a full-stack developer with 5 years of experience in Excel development. Please contact me if you are looking for an excel expert. I'm looking forward to hearing from you, Thanks Daha Fazla

$222 USD in 10 gün içinde
(9 Değerlendirme)
4.0
ayeilyurt

Hello, The task is to match text filenames with the corresponding company on the excel file and write the .txt filename to Column F. As an answer to your 2nd question there might be naming differences as you poi Daha Fazla

$222 USD in 3 gün içinde
(3 Değerlendirme)
3.1
arash18k

Hi, first answering your question: Q1: Yes I understand that you need to hire multiple people Q2: We need to pars each word of Text file name, and for every word check which one is contained in company name (Since t Daha Fazla

$150 USD in 5 gün içinde
(4 Değerlendirme)
3.3