Em Andamento

CSV Formatted Text Filter & Extraction Tool


I have a requirement for a tool that will allow the import of txt files in CSV format and CSV files.

(It needs to handle more than 1 file to be imported at 1 time ideally.)

This tool will then filter this data based upon 1 or 2 specific filters and then extract all the filtered data into separate CSV files for EACH filter.

It will need to use a specific naming convention for naming the CSV files for extraction that identifies filter 1, filter 2 where used & current date.

It should allow for folder creation & selection for saving the filtered CSV files.

Below is further details:

A single or batch of txt file(s) (csv formatted) to be imported into the tool.

I can manually put into a full csv format but ideally would like to be able to import the txt file or the CSV

The file has a list of various information including contact details, ip, url etc. Typically 13 or 14 headers but could be more or less.

The Column headers can vary so the tool needs to recognize the headers I will place into it or into the file itself if needed.

I need the tool to automatically sort the data by url in alphabetical order (A-Z) & group all the same url data together.

I then need an Option to place this data into my own custom categories & it get sorted level 1 by category & then level 2 by url.

Then I need to be able to export the data quickly via 3 options:

1 - Only by url filter

2 - By group filter and then by url filter

3 - By group filter (if this is selected extracted data is combined together under Groups specified and urls are A - Z within it)

So I may have just 4 extracted files if I only have setup 4 custom categories.

I will require the system to generate ALL the CSV files to export in 1 go with a naming reference of:

1) Category_URL_DATE (example Grants_GoForGrants_051113)


2) URL_DATE (example GoForGrants_051113)


3) Category_Date (example Grants_051113)

The url should drop the .com .net etc extension

Date should be DDMMYY format

Underscore to be used to distinguish the separate elements.

The tool needs to allow me to specify the folder to save ALL the generated CSV files.

Once SAVE is clicked all the generated csv files will be saved with correct naming into the folder specified.

And each file will have JUST the filtered data for that url and category, or just the category, or just the url. (Depending on option chosen)

The process of the txt or CSV MAIN files being filtered & placed into individual filtered files NEEDS to be automated.

Habilidades: Arquitetura de software, Desenvolvimento de Software, Teste de Software

Ver mais: system level architecture, software testing tool, automated software testing, filter sort, correct csv, automated testing, import tool, csv column format, testing requirement, net txt csv, import files folder, text selected, tool folder, column text, csv text file, folder tool, formatted, software testing process, date extraction, filter option, details testing tool, underscore, csv generate, filter list, filter category

Acerca do Empregador:
( 100 comentários ) United Kingdom

ID do Projeto: #5097268