I gang

Custom csv filter tool

Dear Coders,

I need a simple tool to filter a number of URL's based on criteria I enter. I have define the criteria below as default however I'd like to be able to edit these OR add more.

The fields that meet the criteria will be flagged with REMOVE in the first column and coloured RED (will need to add this column (labelled STATUS) in the first column position)

There will be about 12 columns of data - sample file included.

We first need to define the columns and then set the rules as follows:

If Domain PR (column) = 0 or N/A and OBL (column) >40 then flag

If OBL (column) > 40 and Bad Word Count (column) > 3 then flag

If Title (column) has the word "suspended" or "error" or "page could not be found" or "page not found" within the title then flag (not case sensitive)

If Domain PR (column) = 0 or N/A and Word Count (column) is 24 then flag

If Domain PR (column) <1 and Word Count (column) 3 then flag

The results are then displayed with the REMOVE status shown.

We can then create a TXT file including ONLY the Flagged results with a simple "EXPORT FLAGGED LINKS" button.

We can also export all links for manual sorting.

During export, any duplicate URL's are removed.

Regards,

Simon

Færdigheder: .NET, Excel, Software Arkitektur

Se mere: csv filter tool, custom csv filter tool, excel duplicate, excel data sorting, net excel add, export page excel, data export net, excel count, excel custom filter, excel export txt, file filter excel, url tool, net txt csv, excel custom number, word csv, excel export txt file, excel number custom, excel sorting, remove bad links, page export word, excel data csv, net create csv file, add excel file word, excel create custom file, create excel csv file

Om arbejdsgiveren:
( 324 bedømmelser ) Diamond Creek, Australia

Projekt-ID: #4047372

Tildelt til:

mrbrave

Lets start and get it done in 3 hours..

$50 USD in 0 dage
(62 bedømmelser)
5.3

3 freelancere byder i gennemsnit $83 for dette job

eried

Hi, I think I can make your application

$160 USD in 12 dage
(74 bedømmelser)
5.5
cosconeaionut

Computer science student here :)

$40 USD på 1 dag
(7 bedømmelser)
3.6