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 →
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.
38 freelancers are bidding on average $6/hour for this job
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
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