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.