已关闭

Rename, then Combine and then do some operations on .csv/.excel Files

One of my client purchase data from a company → The data is the domain registered with details such as Name, email, Phone etc.

The details are divided into folders based on countries such as →

Australia

New Zealand

USA

UK

Ireland and all other Countries.

In this country Folder, a file is kept, which is normally of the sort [url removed, login to view] that means the name is same in all the folders [url removed, login to view], for example.

See this Video → [url removed, login to view]

Operation 1→ Change the name of the file, which is CSV or excel sort of format to country format such. Precisely this image → [url removed, login to view], but you have to make it in such a manner that it can handle any extension in excel. For example, in Australia folder, the "[url removed, login to view] or [url removed, login to view]" should be changed to [url removed, login to view] and in zimbabwe folder, it should be changed to zimbabwe_1.csv. Similarly for other countries. Then collect these modified names extension in one folder named common. Got It?

Operation 2 → Combine all the modified Files into one big File. I am showing you structure of the sample [url removed, login to view] file see this video → [url removed, login to view] We will need 3 columns to be combined = Domain Name, Full Name, and Email. While doing this combination it will be advisable If 4th column can be created which will have entry like from where the entry is coming such as Australia_1, Zimbabwe_1

Operation 3 → Concatenation result in a new column like this → Full Name <Email> that means name and email concatenated in the above format that I showed you.

技能: 数据输入, 数据挖掘, 数据处理, Excel, 微软Office

查看更多: macro excel concatenate files csv, script combine excel files, excel plot csv files, combine worksheets excel files, can combine excel files, combine excel files using vbscript, can excel plot csv files, vbscript combine excel files, access database combine excel files, visual basic combine excel files, excel combine excel files, operations columns excel files, creating excel report csv files, combine data excel files, combine excel files

关于此雇主:
( 44个评论 ) Noida, India

项目ID: #11686319

38 威客就此工作平均出价 $6/小时

faheems189

Hi there, I have read all the details and I am ready to do sample work for you. awaiting for your positive response. Best Regards Faheem S.

$4 USD / 小时
(95条评论)
6.1
katilinas

Hello. 35 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!

$8 USD / 小时
(64条评论)
5.3
$5 USD / 小时
(6条评论)
5.4
JohnNuman

Greetings, I have reviewed the provided task details. I might have some follow up questions that I'll ask once I have your attention. In general, I have assessed that my team is fully capable of taking up this task a 更多

$6 USD / 小时
(4条评论)
4.9
datadexterous

Hi there, I'd like to be considered for your project. I have a team of 5 members, expert in excel and data entry work. If you award us this project, we can complete it in your budget & time frame. If you'd like to v 更多

$4 USD / 小时
(43条评论)
4.6
Batbuncho

Hello Sir, Greeting from Europe. Sound like a good project for me. I've done similar project like this before. If you choose me I can start working immediately. My bid for this project is 20$. Regards, Ivanov

$2 USD / 小时
(26条评论)
3.9
adilsyed123

Expert here to do and complete this project professionally and quickly, I have done similar projects, I can do trial work before hire me sir , will wait for your. THANKS

$5 USD / 小时
(18条评论)
3.6
solarqw

Hi, I have watched the video and most of the operations are just file operation based. I can use java to finish your task quickly. I am ready to work now

$5 USD / 小时
(7条评论)
3.0
$5 USD / 小时
(5条评论)
2.7
MykolaDudych

Hello, I am interested in your offer and I am ready to cooperate. I have experience in data entry. I have experience of work in Excel

$2 USD / 小时
(3条评论)
2.6
anusha1111

A proposal has not yet been provided

$5 USD / 小时
(1条评论)
0.3
joycejoseph9

Fast and prompt Delivery Team of 6

$3 USD / 小时
(0条评论)
0.0
$5 USD / 小时
(0条评论)
0.0
jhoye08

Dear Sir/Madam, I am very interested in this opportunity and I believe that my skills will make me the best candidate for this position. For the past years, I worked as a web researcher, email corresponding agent 更多

$2 USD / 小时
(1条评论)
0.0
kwljit02

I can do as you want and as quick as you say. "every expert was once a beginner" Thanks in anticipation

$10 USD / 小时
(0条评论)
0.0
ahmadri

i can make it faster than the other do this job, give me a chance and i'll prove my word, thank you sir

$4 USD / 小时
(0条评论)
0.0
godendaal

Good day I trust you are well? With 7 years as a Senior Data Analyst, Data Integrity Analyst and SQL report writer I am the ideal candidate for this project. Kindly contact me should you require any further deta 更多

$5 USD / 小时
(0条评论)
0.0
$2 USD / 小时
(0条评论)
0.0
$55 USD / 小时
(0条评论)
0.0
$5 USD / 小时
(0条评论)
0.0