Đã hoàn thành

Clean, format and validate data

There are three data files

1. Organizers and Events

Requirement

Validate emails

Remove records that do not have emails that validate

Provide 2 files:

a). File - with records that only contain validated emails

b). File with old data - email not validated

2. Exporters

Requirements

a) Shorten Product Category Name - in all Product Category 1-7 columns

Keep short name the same in all columns

b) Make 3 new column fields "Title" + "First Name" + "Last Name"

Copy Temp Name to new above fields

Do not change Mrs. or Ms.

All names that do not have Title (Mr. Mrs. etc) - assign Title Mr.

c. Make new Column - "Email 2"

Where there is more than one email in Email column - eg. [login to view URL]@[login to view URL]@[login to view URL]

Then delete the "/" and copy 2nd email ID saket@[login to view URL] to new Email 2 column

d. Validate emails

e. Provide 2 files

e1) File - with records that only contain validated emails

e2) File with old data - email not validated

3. Importers

Requirements

a) Shorten Product Category Name - in all both Product Category columns

Keep short name the same in all columns

b) Make 3 new column fields "Title" + "First Name" + "Last Name"

Copy Temp Name to new above fields

Do not change Mrs. or Ms.

All names that do not have Title (Mr. Mrs. etc) - assign Title Mr.

c. Make new Column - "Email 2"

Where there is more than one email in Email column - eg. [login to view URL]@[login to view URL]@[login to view URL]

Then delete the "/" and copy 2nd email ID saket@[login to view URL] to new Email 2 column

d. Validate emails

e. Provide 2 files

e1) File - with records that only contain validated emails

e2) File with old data - email not validated

Kĩ năng: Excel

Xem nhiều hơn: format excel data, aircat 500 format radar data, html format cut data excel spreadsheet web page, net validate data using xsd, hst format gps data, export clean format excel, validate code automatically remove errors, automatically format excel data word template, format budget data sheet, convert dat format xls data, business mail format posting data entry, excel format option data nse, excel format store data entery, format bid data sheet, validate data php, xml format import data magento

Về Bên Thuê:
( 14 nhận xét ) Midrand, South Africa

ID dự án: #20897368

Được trao cho:

datakillers

Hi, I am really interested this project and will provide you best solution as usually I am doing. You can you can my profile for reviews and feedback of exiting clients

$84 USD trong 4 ngày
(162 Đánh Giá)
6.6

15 freelancer đang chào giá trung bình $126 cho công việc này

TonmoyRoy111

Hello client I understand the scope of work involved in the project. I would love to help you in this project. So please contact me. Roy

$120 USD trong 3 ngày
(314 Nhận xét)
6.8
andriphone0

Hello, I have working experience of more than 7 year on-Web Research, lead generation, data entry, data mining, lead collection, And all types of scrapping tools like - data toolbar, Visual Web ripper and email address Thêm

$140 USD trong 7 ngày
(71 Nhận xét)
5.7
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects i Thêm

$150 USD trong 3 ngày
(63 Nhận xét)
5.6
RavinduJayzz

Hey there ! I would love to help you out with this project. I am an Excel Expert. I am Great with Excel and a Detail Oriented person, whom delivers given project on deadlines. I read through the entire project and Thêm

$200 USD trong 3 ngày
(17 Nhận xét)
5.2
umairabdillah12

Hi There, I have read your requirements, i'm excel expert with many experience using excel formulas over 10 years, please kindly check my profile. thanks. regards.

$100 USD trong 5 ngày
(7 Nhận xét)
3.4
hasnat0012

Hi, I have read the project description and understand the nature of the work. I can very well do this task with the utmost accuracy and efficiency. You will definitely like my work and I would like to start the work Thêm

$70 USD trong 3 ngày
(1 Nhận xét)
1.4
muhammadwakkar77

Hi ,please accept my proposal . I am expert in data entry who can do quality work within budget and time. I am available right now , please come and will start asap.

$99 USD trong 1 ngày
(1 Nhận xét)
0.6
partgreat801

⭐LOW RATE! HIGH QUALITY&SPEED!⭐ I read your project . Your project is very interesting. I have ever been similar project with your project. I have 8+ years of experience working with python,web scraping, typing, excel Thêm

$99 USD trong 2 ngày
(0 Nhận xét)
0.0
thsvo

Hi, I have gone through your requirements and I can do this task. The skills and resources needed for this project are in my genes. I can assure you for a complete professional work in given time [login to view URL] share comp Thêm

$50 USD trong 7 ngày
(2 Nhận xét)
0.1
youssefeeribe

Hi, I will have plenty of time to do it quickly and in a good way. I am a student and we use all the time and the word excel so I can do it. You need to enter data. I am an experienced data entry operator with the best Thêm

$100 USD trong 6 ngày
(0 Nhận xét)
0.0
cyliaA

hello I am interested, I am at your disposal to realize this project, I will be happy to work with you thank you

$111 USD trong 3 ngày
(0 Nhận xét)
0.0
ramzanalam98

Hi,I am Ramzan and it will be my pleasure to assist you with this project. I have read your project [login to view URL] can expect from me I strong commitment to a deadline, the highest quality, and a fluid/friendly commun Thêm

$100 USD trong 7 ngày
(1 Nhận xét)
0.0
Emmanuelbab

Competent

$222 USD trong 7 ngày
(0 Nhận xét)
0.0
jinjinwu

( ͡ᵔ ͜ʖ ͡ᵔ ) Hi, client. I saw your posting with interesting. I have experience with your request skills. So I think I can solve your project asap I will wait for your response. Kindly regards.

$250 USD trong 5 ngày
(0 Nhận xét)
0.0