Find Jobs
Hire Freelancers

Utilize Desktop Softwares (Microsoft Excel or Access) to EXTRACT specific data from TEXT files

$30-250 USD

Cerrado
Publicado hace casi 5 años

$30-250 USD

Pagado a la entrega
Sorry, not sure if "Specialty" of Desktop Software Development is correct category. I am looking for help to use desktop softwares (microsoft excel, access, etc), that will utilize network switch output in text format, to EXTRACT or EXTRAPOLATE specific data of my choosing. I dont have access to Web Servers, Apache, Linux, etc...just Windows Desktops with Microsoft Applications, so I cannot use anything else. The output is mostly consistent, each line containing keywords/elements, that I'd like help taking the data out of the text file and organizing it in either Excel or Access, in a way to where I can then filter, organize, report on even perform additional actions against later. The text file can be from ONE SWITCH containing 1000's of lines, or it could be from ALL switches, containing 100,000's of lines. Again, the data will be similar whether 1 SWITCH or 150 SWITCHES, its the text file that will be smaller or larger, but output will be similar either way. The goal is to use Excel or Access (regular desktop softwares), to point to and pull in from a text file, and pull out ONLY specific lines of data, but after pulling it out...organizing it in a way that it can then be filtered, sorted, reported on, etc. An example: 1 output text file can range of lines in output data, like 1 switch output (approx 1,050 lines) to another switch stack output (approx 32,000 lines), or possibly against all switches outputs combined (approx 365,000 lines) These lines are specifically about the switches interfaces (ports), statistics of the port(s), etc. But, 95% +/- of the data in the output is useless to me....as to acquire the data sought, I must run specific commands that in turn, supply extraneous/extra/unwanted output - so most of the lines in the file are not usable nor wanted....this is where the "EXTRACT" or "EXTRAPOLATION" comes in...I only want/need specific lines from the text file like the following: Switch Name (hostname of switch) Physical Interface (ge-1/0/20, or xe-1/1/19) Carrier Transitions (counts of flaps/bounces) Drops (packet loss count(s)) Last Flapped (recorded flap/bounce/up/down, incl time, weeks, days, hours, minutes summary) Statistics Last Cleared (never, or specific date, time, weeks, days, hours, minutes summary) Ideally, I'd like to see the following format in the end - again, whether it is ONE SWITCH, TWO SWITCHES, TEN SWITCHES or ONE HUNDRED FIFTY SWITCHES....the data output remains alike in the text file...just need to get ONLY info wanted, from TEXT FILE into Excel or Access, organized in a way that it can then be easier, faster, better to search, filter, find and report on specifics. I will upload 2 files as examples to this project for review; 1 = text file of switch output, command(s) issued and returned results from switch and its layout/format 2 = a possible (preferred) way i would like to see the end data (after pulling out ONLY/JUST the data desired from the text file) - rows/columns and how it can then be further manipulated easier, faster and more efficiently once pulled in and organized. The types/kinds of filtering I would most likely use: Carrier Transitions: highest numbers/values Drops: highest numbers/values Last Flapped: oldest dates or recent dates Statistics Last Cleared: oldest dates or recent dates I must be able to SUCCESSFULLY test the final delivered solution against the file(s) I have, to ensure that even with ONE SWITCH, TEN SWITCHES, FIFTY SWITCHES or ONE HUNDRED FIFTY SWITCHES, the solution delivered will work correctly and properly with ANY text file used. It will EXTRACT and ORGANIZE only the specific data I want from the file. Freelancer must be willing to take time to show Buyer process, to Buyer can understand how it works, why it works the way it does and learn from the delivered solution.
ID del proyecto: 19439844

Información sobre el proyecto

26 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
26 freelancers están ofertando un promedio de $160 USD por este trabajo
Avatar del usuario
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$250 USD en 4 días
4,9 (315 comentarios)
7,9
7,9
Avatar del usuario
Hello, I’m an Excel expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.
$150 USD en 3 días
4,9 (327 comentarios)
7,3
7,3
Avatar del usuario
Hi, I am an Excel automation expert with experience in this field for the past 15 years. I propose to provide you with an Excel macro automated solution. From Excel, user will be able to choose the text file with date which will then be imported to Excel based on the specifications. In case I take on the project, would request you to provide me with sufficient sample data for testing and fine tuning. Let me know if you are interested. Regards, Arul
$200 USD en 3 días
5,0 (174 comentarios)
7,3
7,3
Avatar del usuario
Greetings! Thanks for detailed requirements. I have reviewed the input and output files and the requirements and can come up with an Excel based parsing solution. Being a full time freelancer working exclusively on Excel based projects, I work on developing such Excel based solutions every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. Have a Great Weekend! Srinivasan Krishnamoorthi
$120 USD en 4 días
5,0 (187 comentarios)
6,8
6,8
Avatar del usuario
Hello, As an experienced software developer, i am very much interested to develop the required application to import the data from text files. Looking forward to have a positive response from you. Thanks
$160 USD en 3 días
4,9 (124 comentarios)
6,4
6,4
Avatar del usuario
Hello. I have good skills in "Data Extraction, Excel, Microsoft Access". I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project description carefully and i can do it. I 'll do my best till you satisfy if you want me. Contact me please. Thank you. Yang L.
$140 USD en 3 días
4,8 (94 comentarios)
5,9
5,9
Avatar del usuario
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/Excel /VBA. I can code that using SQL/ADO coding within Access. I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all my projects here I've developed for Ms Access/VB/SQL/Excel projects. Thank you for your consideration. Zura
$250 USD en 3 días
4,7 (52 comentarios)
6,1
6,1
Avatar del usuario
Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards
$133 USD en 10 días
4,9 (29 comentarios)
5,0
5,0
Avatar del usuario
Hello. I'm windows application developer. I'm software engineer and C&C++ perfecter. Also i have C#, VB, java, python ,SQL and so on. Especially I'm algorithm expert. I'm sure that you may feel nice from me. Regard from you.
$155 USD en 3 días
4,8 (12 comentarios)
4,3
4,3
Avatar del usuario
Hi, I am a professional Access developer I have done many projects in Access have a look at my profile. I can finish the project to extract data from text file using Access send me more information please
$177 USD en 3 días
5,0 (6 comentarios)
3,7
3,7
Avatar del usuario
Hi. I am an experienced .Net developer and I can do you task with C# and .NET. I'm always provide all sources and provide lifetime support for all my projects in future. I can do this task as windows desktop utility for get CSV (or exact Excel) from input data.
$220 USD en 5 días
5,0 (5 comentarios)
3,2
3,2
Avatar del usuario
Please review my profile I am working with skills that you required for this job from 16 years. I am working with MS Access,Excel,MS SQL and VBA from long time. I can definitely help you in this job, to make your database design very proficient. I have done lots of split databases with MS Access as Front-end and MS Access/MS SQL/MySQL/Teradata database as back-end. I will show my advanced skills in MS Access/Excel via arrange demo via screen sharing session etc. Please contact me with your interest to discuss next.
$250 USD en 5 días
5,0 (1 comentario)
0,6
0,6
Avatar del usuario
I am seeking for a part time work in order to gain some experience and i am willing to do any job. Therefore, this is some of the skills of mine: -slideshow presentation -photo editing -data entry -article review -building system -resume -logo editing/design MICROSOFT WORDS = 10/10 EXCEL = 10/10
$35 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I can automate data extraction and entry for faster job completion. I did data scraping from websites for content creation automation usage.
$166 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Please give me an opportunity. I'm native spanish speaker and englis fluent speaker. I already have experience doing translations. I would want to have this job so I can have more experience and grow my CV. I'm very competent and Always trying to do my Job as good as possible and more. Also I'm very capable of doing anything that requested so the fact that I'm not an expert in this is not a problem. I'm also very fast and can have the work done faster than average.
$140 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi there.... We can make excel to read the text files, find the required data and arrange it as per the requirements using excel VBA coding. We have gone through the sample file as well. If the data is well organised we will be able to get the required data. We would be happy to help you with your work. Kindly allocate the project so that we can start. Thank you.
$83 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, my name is Fabrizio I'm specialized in automation projects, I have a course in Udemy with Autoit, a software that can automate anything I can filter your file and sort by anything you want, tell me if you are interested.
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have years of experience using data extraction and macros
$222 USD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
We are a group of software developers with 10 years experience. These are the fields we are specialized in : - .NET and .NET Core and ASP .NET MVC Development - SQL Server and High Performance Stored Procedure Development - Jquery, JavaScript, TypeScript and Fornt-end Development - Angular (specially angular 4+) Development - Android Development (Native Java and Cotlin) - Back-End and Front-End Development - Web site Tune up (High Performance Website development) - Test Back-End, Front-End and Mobile App professionally
$140 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have solid experience in converting text files into excel files. I will take you through the process in a detailed manner and ensure that you understand how each part of the conversion takes place.
$111 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Mount Vernon, United States
5,0
42
Forma de pago verificada
Miembro desde oct 25, 2003

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.