Shell Script for Data Extraction and Manipulation

已完成 已发布的 2 周前 货到付款
已完成 货到付款

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脚本 Bash Scripting Linux Bash

项目ID: #38040018

关于项目

18个方案 远程项目 活跃的2 周前

授予:

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 更多

$50 USD 在2天内
(0条评论)
0.0
(169条评论)
5.7

有18名威客正在参与此工作的竞标,均价$136/小时

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. 更多

$80USD 在1天里
(43条评论)
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.

$170USD 在1天里
(12条评论)
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 更多

$140 USD 在7天内
(4条评论)
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.5USD 在1天里
(3条评论)
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 更多

$50 USD 在6天内
(1条评论)
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 更多

$140 USD 在2天内
(0条评论)
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 更多

$140 USD 在7天内
(0条评论)
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 在3天内
(0条评论)
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 更多

$140 USD 在7天内
(0条评论)
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.

$140USD 在1天里
(0条评论)
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 更多

$200 USD 在2天内
(0条评论)
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 更多

$200 USD 在2天内
(0条评论)
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 更多

$180 USD 在5天内
(0条评论)
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.

$140USD 在1天里
(0条评论)
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 更多

$140 USD 在7天内
(0条评论)
0.0