processing JSON file in bash using jq

Question

I have a bash script

counter=0
for file in /home/ec2-user/Workspace/events_parts/*
do
        counter=$[counter + 1]
        event=$(cat $file | jq '.Event')
        echo $event
        if [ "$event" = "Time Exceeded" ]  || [ "$event" = "Load Time" ]; then
                echo "Coming Here"
                jq ".url = \"$(jq '.Message' $file | sed 's/.*proxy=\([^&]*\).*/\1/')\"" $file 
        else
                jq ".url = null"
        fi
done
~

In the bash script above I am trying to extract Event field from a JSON file and check for two possible values.if [ "$event" = "Time Exceeded" ] || [ "$event" = "Load Time" ]; is not workign as I would expect. I have verified that the values that I am comparing against are indeed there.

@Cyrus - ok, reopened - but the OP should add more descriptive headlines. — clt60
– clt60, Commented Mar 18, 2015 at 1:25

Cyrus · Accepted Answer · 2015-03-18 01:30:05Z

2

Check once if there are leading or trailing unwanted characters (whitespace, newline ...) in output of cat $file | jq '.Event':

cat $file | jq '.Event' | hexdump -C

Update:

Replace

[ "$event" = "Time Exceeded" ]

by

[ "$event" = "Time Exceeded." ]

or replace by

[ "${event%.}" = "Time Exceeded" ]

or replace by

[[ "$event" =~ "Time Exceeded" ]]

to match a substring. ${event%.} crops a trailing ..

edited Mar 18, 2015 at 1:30

answered Mar 18, 2015 at 1:11

Cyrus

90.2k15 gold badges112 silver badges173 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

liv2hak Over a year ago

"Time Exceeded". There is a "." at the end.

Collectives™ on Stack Overflow

processing JSON file in bash using jq

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related