Find Jobs
Hire Freelancers

CSV Formatted Text Filter & Extraction Tool

$30-250 USD

En curso
Publicado hace más de 10 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 5097268

Información sobre el proyecto

5 propuestas
Proyecto remoto
Activo hace 11 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos

Sobre este cliente

Bandera de UNITED KINGDOM
United Kingdom
5,0
100
Forma de pago verificada
Miembro desde ago 27, 2002

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.