Shell Script for Data Extraction and Manipulation

Completado Publicado hace 2 semanas Pagado a la entrega
Completado Pagado a la entrega

I'm in need of a bash script to automate data parsing from a CSV file.

Please see [login to view URL] (attached) for actual source data.

The data is separated with a semi-colon (;).

Headers (10 columns) as follows:

Server ID;Sponsor;Server Name;Timestamp;Distance;Ping;Download;Upload;Share;IP Address

My end goal is shown in [login to view URL] (attached).

The data is separated with a comma (,).

Headers (5 columns) as follows:

Date,Time,Download,Upload,Ping

Where:

* Date is formatted in YYYY-MM-DD

* Time is HH:MM

* Download, Upload, and Ping are rounded to the nearest integer.

Now for the technical challenge...

The Timestamp data is presented in UTC format to great precision:

2024-04-18T00:05:02.401204Z

Somewhere in the script, I'd like a variable representing the offset from UTC time, like:

# offset from UTC

offset=-4

Running the above date through that offset into the target format would yield

2024-04-17,20:05

---

Pure bash script, no third party tools.

Shell Script Bash Scripting Linux Bash

Nº del proyecto: #38040018

Sobre el proyecto

18 propuestas Proyecto remoto Activo hace 2 semanas

Adjudicado a:

tanette

Hi there! I'm Tanette, a seasoned Linux programmer with an affinity for problem-solving and a wealth of experience in Linux and networking. My expertise in Linux programming includes thorough knowledge of shell scripti Más

$50 USD en 2 días
(0 comentarios)
0.0
(169 comentarios)
5.7

18 freelancers están ofertando un promedio de $136 por este trabajo

aencode

Hi there, I can provide you pure bash script and no third party tools. This bash script will parse and convert your CSV file into desired format. I can implement your time (UTC) conversion as mentioned in description. Más

$80 USD en 1 día
(43 comentarios)
5.1
lkhelladi

Hello, I'd be glad to develop the CSV file formatting bash script for you , as required in the project description . Looking forward to chat with you soon for more details. Best regards. Lyes.

$170 USD en 1 día
(12 comentarios)
4.5
AmazingEngr76386

With my extensive experience in Linux and a special knack for bash scripting, I am the ideal candidate to help you automate the data extraction and manipulation required to turn your source file into your desired targe Más

$140 USD en 7 días
(4 comentarios)
4.6
jmgjunior

Hey, I have experience with this and I think it is something I can help you with... Does this has deadline or something? hope you can reach me out!

$237.5 USD en 1 día
(3 comentarios)
2.9
ajeshjanardanan

Hi Maurice A., How are you doing? As a professional developer with expertise in Linux, Bash Scripting, Shell Script and Bash, I eagerly anticipate the opportunity to complete this project for you. Please drop me a mess Más

$50 USD en 6 días
(1 comentario)
2.0
shah812

As a full stack developer with more than 12 years of experience, I've had the opportunity to master numerous tools and technologies including Linux which is relevant to your project. With this skill-set and a strong ba Más

$140 USD en 2 días
(0 comentarios)
0.0
vikatarasiuk1995

As an experienced and versatile Full Stack Developer with a strong background in Linux environments, I am well-equipped to tackle your project requiring a pure bash script. With my extensive skills in languages like Ja Más

$140 USD en 7 días
(0 comentarios)
0.0
masterofnon

Hey there, I have gone through your project description, from initial understanding, I am confident that I can deliver this job. I have seen the attachment as well. Send me a message through chat to have a discussion

$110 USD en 3 días
(0 comentarios)
0.0
amarmUK

I bring to the table a vast array of skills and experiences that make me an ideal fit for your project. My profound knowledge and extensive work with command-line tools, specifically Linux operating systems, allow me t Más

$140 USD en 7 días
(0 comentarios)
0.0
mariaannk

Would love to assist, can get out the door in 24 hours or less. We will use exclusively bash and make sure we have the offset variable set for you.

$140 USD en 1 día
(0 comentarios)
0.0
filip345

***I CAN DO IT. ** Hi Client. I have reviewed your project requirements carefully. I have lots of experience in programming but I have less reviews because of less chance. I am mastered all skills you mentioned. If you Más

$200 USD en 2 días
(0 comentarios)
0.0
bhupen4work

Dear Client, I am writing to express my keen interest in the opportunity you have posted for a Bash Script Developer to automate data parsing from a CSV file. Your project's requirements align perfectly with my expert Más

$200 USD en 2 días
(0 comentarios)
0.0
CamiloLopez07

I'm an expert in task automation and bash scripting, and I'd be happy to help you create the script you need. We'll use .sh files for script execution and Python for data manipulation and creating new files. Given tha Más

$180 USD en 5 días
(0 comentarios)
0.0
erwinbryan67

✅✅Dear client.✅✅ As a python expert, I can give you python script and csv file in 1 hour. please award me. Thanks.

$140 USD en 1 día
(0 comentarios)
0.0
Darko999

Hello, how are you? I'm Darko, a seasoned full-stack engineer with 8 years of experience and Linux as my forte. Your project requires the precision of a skilled hand and a nuanced understanding of data manipulation, a Más

$140 USD en 7 días
(0 comentarios)
0.0