Find Jobs
Hire Freelancers

CSV Formatted Text Filter & Extraction Tool

$30-250 USD

In Progress
Posted over 10 years ago

$30-250 USD

Paid on delivery
Hello, 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) Or: 2) URL_DATE (example GoForGrants_051113) Or 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.
Project ID: 5097268

About the project

5 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED KINGDOM
United Kingdom
5.0
100
Payment method verified
Member since Aug 27, 2002

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.