Annulleret

Excel Filtration tool

Project Specification (Excel Filtration tool)

I need this script in PHP

I am looking for a script which could help me to manipulate excel data. I, normally work on excel with data record size of 25k - 35k and struggle with duplicate records

Please checks my requirements

First Screen – Two filtration options with radio button

1. Single data option

2. Double data option

For Single data option – Their should be a option to upload excel file that will have data in one column

Now I require following filtration option with radio button

1. Remove Duplicate Records

2. Show all Duplicate Records

3. Remove Records with a specific keyword – say I have a data of 10k, column have full name (first name and Second name – “Raj Kumar”, “John Rights” Simmon Gibbs” Etc and I want to remove all records which have say “Kumar” word, it may be one word or may be multiple words)

4. Remove all multiple email ids with same domains – if excel column have data of 50k (email ids) than all ids with same domain should be remove

5. Show all multiple email ids with same domains – if excel column have data of 50k (email ids) than show all ids with domains which have multiple ids in record

6. Keep one email id and remove rest of all multiple email ids with same domains – if excel column have data of 50k (email ids) than keep one email id and remove rest of all ids with domains

[* for options 4, 5, 6; I would be able to give a list of domains which would be exceptions – like [url removed, login to view], [url removed, login to view], [url removed, login to view] etc

This may be predefined but require access to edit the list]

For Double Data Option - Their should be a option to upload excel file that will have data in 2 columns

1. Remove Duplicate Records

2. Show all Common records

3. Remove Records with a specific keyword – say I have a data of 10k, column have full name (first name and Second name – “Raj Kumar”, “John Rights” Simon Gibbs” Etc and I want to remove all records which have say “Kumar” word, it may be one word or may be multiple words. If excel file have records like – Candidate Name (First Column) and Email id (Second Column) and we want to remove all candidate those have say “Kumar” in his name than respective email ids should be remove as well. I need fine data after process, right email id with its respective candidate.)

4. Remove all multiple email ids with same domains – if excel columns have data of 50k (email ids) than all ids with same domain should be remove

5. Show all multiple email ids with same domains – if excel column have data of 50k (email ids) than show all ids with domains which have multiple ids in record

6. Keep one email id and remove rest of all multiple email ids with same domains – if excel column have data of 100k (email ids) than keep one email id and remove rest of all ids with domains

[* for options 4, 5, 6; I would be able to give a list of domains which would be exceptions – like [url removed, login to view], [url removed, login to view], [url removed, login to view] etc

This may be predefined but require access to edit the list]

I need output in excel

I need source code

Færdigheder: PHP

Se mere: yahoo rest, we excel, tool specification, tool john, show full name, rest specification, Need help in excel, me excel, looking for duplicate data in excel, kumar gmail, i need help with excel, gmail tool, gmail edit, excel specification, need help with excel, work on excel, keyword tool , john raj, excel duplicate, code columns excel access, keep record access, multiple excel, yahoo com gmail, excel specific, data filtration

Om arbejdsgiveren:
( 652 bedømmelser ) Ghaziabad, India

Projekt-ID: #972278

5 freelancere byder i gennemsnit $117 for dette job

pratham2003

Bid details sent via PM.

$110 USD in 5 dage
(81 bedømmelser)
5.6
arun88m

Hi, I have good experience with handling excel files. Please check PM for more details. Regards, Arun.

$120 USD in 4 dage
(19 bedømmelser)
4.2
gauravbijnori

ready to start.... php-mysql expert here can be done using csv and mysql

$150 USD in 2 dage
(10 bedømmelser)
3.6
shimona

Please check PMB.

$105 USD in 3 dage
(2 bedømmelser)
2.5
mescot

We have excellent team to offer PHP Development, Sql, Joomla,Drupal and Wordpress Development,Ajax and SEO At the Web Development Center we have the most qualified and experienced web developers ready to help you desig Mere

$120 USD in 5 dage
(0 bedømmelser)
0.0
bhagyad

Hello Seexpert, We have top notch techies for doing this type of data handling [url removed, login to view] bidding value is negotiable. Thanks and Regards, Bhagya

$100 USD in 20 dage
(0 bedømmelser)
0.0