shell script code below

#$!/$bin$/$bash

# Script to parse logs and generate CSV report

# Check if the correct number of arguments is provided

if $["$$#$"-$ne $3]$; then

echo "Usage: $./$asgn$05.$sh $"$

exit $1$

fi

log$\_$file$=$$$1$

regex$\_$pattern$=$$$2$

json$\_$fields$=$$$3$

# Define the fields in the exact order required for CSV output

fields$=("$action$"$ "additional$\_$info" "data$\_$amount" "location$\_$lat" "user$\_$id$")$

# Initialize an associative array to hold field values for each line

declare $-$A field$\_$values

# Function to reset field values to $"$N$/$A$"$

reset$\_$fields$()\{$

for field in $"$$$\{$fields$[$@$]\}"$; do

field$\_$values$["$$field"$]="$N$/$A$"$

done

$\}$

# Initialize CSV header

header$=$$$($IFS$=,$; echo $"$$$\{$fields$[*]\}")$

echo $"$$header"

# Process each line in the log file

while IFS$=$ read $-$r line; do

# Reset field values for each new lineue"

reset$\_$fields

if $[["$$line" $=$~ $^[$a$-$zA$-$Z$0-9\_]+=]]$; then

# Pawhile IFS$=\text{'}=\text{'}$ read $-$r key value; do$45)$

# Strip whitespace and quotation marks

key$=$$$($echo $"$$key" $|$ xargs$)$

value$=$$$($echo $"$$value" $|$ xargs $|$ sed $\text{'}$s$/"//$g$\text{'})$

# Assign value to appropriate field if it's in the fields array

if $[["$ $$\{$fields$[*]\}"==*"$ $key $"*]]$; then

field$\_$values$["$$key"$]="$$value"

fi

done $<<<"$$line"

# Parse JSON fields

elif $[["$$line" $=$~ $^\{.*\}$$ $]]$; then

for json$\_$field in $$($echo $"$$json$\_$fields" $|$ tr $\text{'},\text{'}\text{'}\text{'})$; do

# Extract JSON field value using jq

field$\_$name$=$$$($echo $"$$json$\_$field" $|$ sed $\text{'}$s$/\backslash ./\_/$g$\text{'})$

value$=$$$($echo $"$$line" $|$ jq $-$r $".$$json$\_$field $//\backslash "$N$/$A$\backslash "")$

field$\_$values$["$$field$\_$name"$]="$$value"

done

fi

# Output CSV row with values in the correct order

row$=""$

for field in $"$$$\{$fields$[$@$]\}"$; do

row$+="$$$\{$field$\_$values$[$$field$]\},"$

done

echo $"$$$\{$row$\%,\}"$ # Remove trailing comma

done $<"$$log$\_$file"

THE OUTPUT I GET

action,additional$\_$info,data$\_$amount,location$\_$lat,user$\_$id

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,12$

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

login$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,25$

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

purchase,N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$Discount applied,N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,18$

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,42$

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

logout$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,15$

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

purchase,N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,33$

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

login$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

N$/$A$,$N$/$A$,$N$/$A$,$N$/$A$,$N$/$A

and the output goes on and on$,$ my expected output is

BUT MY INSTRUCTOR SAID L SHOULD BE GETTING THE SAME OUTPUT AS BELOW

action,additional$\_$info,data$\_$amount,location$\_$lat,user$\_$id login$,$N$/$A$,$N$/$A$,40\mathrm{.}7128,45$ purchase,Promo code applied,$200,$N$/$A$,58$ N$/$A$,$N$/$A$,$N$/$A$,51\mathrm{.}5074,32$ logout$,$N$/$A$,$N$/$A$,$N$/$A$,100$ purchase,N$/$A$,120,$N$/$A$,21$

sample.log below a few line

$---$

timestamp$=2023-10-01$T$08$:$15$:$30$

user$\_$id$=12$

location$=\{"$country$"$:$"$US$",$"city":"San Francisco","lat":$37\mathrm{.}7749,$"long":$-122\mathrm{.}4194\}$

action$=$login

$---$

timestamp$=2023-10-01$T$09$:$30$:$22$

user$\_$id$=25$

data$=\{"$value$"$:$20,$"type":"purchase","amount":$500\}$

action$=$purchase

additional$\_$info$=$Discount applied

$---$

timestamp$=2023-10-01$T$11$:$05$:$50$

user$\_$id$=18$

data$=\{"$value$"$:$10,$"type":"login$"\}$

$---$

timestamp$=2023-10-02$T$07$:$22$:$11$

user$\_$id$=42$

location$=\{"$country$"$:$"$US$",$"city":"Los Angeles","lat":$34\mathrm{.}0522,$"long":$-118\mathrm{.}2437\}$

action$=$logout

status$=$failed

$---$

timestamp$=2023-10-02$T$13$:$47$:$10$

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

l. Introduction In this programming assignment, you will create a front end that is, a scanner and a parserfor the intermediate representation, ILOC, that will be used as input in the next two...

Q:

Given code: utils.c (for reference DON'T Modify), utils.h (DON't Modify) and main_template.c (Write Code HERE) --> UTILS.C [DO NOT MODIFY] pasting image cause Chegg character limit >:( --> UTILS.h...

Q:

Introduction and learning objectives When you were learning about operational analysis earlier in the term, we talked about jobs that require multiple visits to the CPU (or servers) to receive their...

Q:

This assignment asks you to write bash shell scripts to compute matrix operations. The purpose is to get you familiar with the Unix shell, shell programming, Unix utilities, standard input, output,...

Q:

This assignment asks you to write bash shell scripts to compute matrix operations. The purpose is to get you familiar with the Unix shell, shell programming, Unix utilities, standard input, output,...

Q:

This assignment asks you to write bash shell scripts to compute matrix operations. The purpose is to get you familiar with the Unix shell, shell programming, Unix utilities, standard input, output,...

Q:

This assignment asks you to write bash shell scripts to compute matrix operations. The purpose is to get you familiar with the Unix shell, shell programming, Unix utilities, standard input, output,...

Q:

This assignment asks you to write bash shell scripts to compute matrix operations. The purpose is to get you familiar with the Unix shell, shell programming, Unix utilities, standard input, output,...

Q:

This assignment asks you to write bash shell scripts to compute matrix operations. The purpose is to get you familiar with the Unix shell, shell programming, Unix utilities, standard input, output,...

Q:

This assignment asks you to write bash shell scripts to compute matrix operations. The purpose is to get you familiar with the Unix shell, shell programming, Unix utilities, standard input, output,...

Q:

In Figure, the pendulum consists of a uniform disk with radius r = 10.0 cm and mass 500 g attached to a uniform rod with length L = 500 mm and mass 270 g. (a) Calculate the rotational inertia of the...

Q:

Prove that if Pr (B | A), then it follows that (a) Pr (A, B) = Pr (A) Pr (B) and (b) Pr (A, B) = Pr (A). Furthermore, show that if, then the two conditions above do not hold as well.

Q:

Faraday's law only applies to materials that are paramagnetic ( i . e . can be magnetixed ) sach as inon. This statement is: true. false.

Q:

Triangle ABC is graphed in the coordinate plane with vertices A 1 1 B 3 4 and C 1 8 as shown in the figure 9 C 1 8 8 5 4 1 9 8 7 6 5 4 3 2 1 0 1 2 3 4 6 7 8 B 3 4 A 1 1 1 2 3 4 5 6 7 8 9 Part B What...

Previous Question Next Question