Find Jobs
Hire Freelancers

Bash script to read text values in files recursively and prepare a new file ready for MySQL

£10-20 GBP

Terminado
Publicado hace más de 5 años

£10-20 GBP

Pagado a la entrega
We have a series of text files which contain lists of log file information in this format -> value1:value2 value1:value2 There is no delimitation around the fields other than the full colon ":" separating the 2 values and obviously a new line at the end of the 2nd value. There are however some errors in these files, some of the lines don't follow the correct format above and we need these removing otherwise we wont be able to use LOAD DATA into MySQL when we come to import them. These files are stored in multiple nested directories, some of which are 5 or 6 levels deep and each directory can contain between 50 and 200 text files. We are looking for someone to write a simple BASH script to run on ubuntu 16.04 in the root directory of all these files. The script will traverse its way down each file and directory and cleanse the data. The script will need to open each file, read it one line at a time and check that each line conforms to the above format. If it is in the correct format, add it to a new "cleansed data" text file in the same (value1:value2) format in the current directory being checked. When its finished reading all the files in that current directory, it will save the cleansed data text file and move onto the next dorectory. We have 98 directories of this data and hundreds of files within them. The output of the script will be 98 "cleansed" text files, one in each directory containing all the correctly formatted lines from all the files in that directory. We'll then use each new cleansed data file with the LOAD DATA facility to upload the new value1:value2 checked pairs.
ID del proyecto: 18159808

Información sobre el proyecto

7 propuestas
Proyecto remoto
Activo hace 5 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
Adjudicado a:
Avatar del usuario
HI, I have ten years commercial Linux experience as a systems administrator. I can write a script to filter your files. Hope to speak with you soon.
£23 GBP en 1 día
5,0 (16 comentarios)
4,6
4,6
7 freelancers están ofertando un promedio de £34 GBP por este trabajo
Avatar del usuario
Bash is one of my best skills. I use it every day. All I would need is a few sample files, and some nodes about data types in the file.
£20 GBP en 1 día
4,9 (381 comentarios)
7,2
7,2
Avatar del usuario
Hello Sir, I am agile safe 4.0 certified I have 7 year of experience in Software development including technologies java, j2ee, spring , hibernate, ,Rest apis, php unix shell scripts, apache tomcat, jboss, server configuration aws, s3 bucket, spring boot, jsp, servlet, html, jstl, jquery, ajax, mysql, oracle, php, codeigniter, bootstrap, css, batch processing, automation, git , svn, github my experience says to follow all the best practices and OOPS concept. I believe in work quality within given time as my experience helps me to achieve this. Please message me so that we can discuss . Thanks in advance.
£10 GBP en 1 día
4,7 (4 comentarios)
3,7
3,7
Avatar del usuario
Hello, I'm interested in the project. Right now I have a small web development company with 2-3 web developers. We are currently working on the back-end of our website and when we fully launch our front-end will be complete. Here is our website that's currently under construction www.dev-trix.com. Please take time to review our services. I'm hopefully looking forward to working with you, thank you.
£18 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I wrote many such nifty content aware scripts. This is doable with shellscript, ruby, perl and almost any language. I will choose the one that will get the job done best. I hope you decide for me and be amazed!
£55 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Lincoln, United Kingdom
5,0
7
Forma de pago verificada
Miembro desde oct 14, 2014

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.