How to remove empty array from Jq in bash script

Question

How I can remove empty parameters from jq output without editing and removing a empty spaces from variable?

My output is, and I need remove this empty values like {"{#PARAMETER}":""}:

{"data":[{"{#PARAMETER}":""},{"{#PARAMETER}":"test1"},{"{#PARAMETER}":"test2"},{"{#PARAMETER}":"test3"},{"{#PARAMETER}":"test4"},{"{#PARAMETER}":""}]}

Reproduce script.

#!/bin/bash

TEST="
test1
test2
test3
test4
"

echo -n "${TEST}" | jq -R -s -c '{data:  split("\n") | map({"{#PARAMETER}": (.)}) }'

It'd be simpler to remove the extra newlines from $TEST, or filter the output from echo before it gets passed to jq. You don't want to do either of those? — John Kugelman
– John Kugelman, Commented Dec 8, 2020 at 22:29
Aside: Always use printf %s "$var" instead of echo -n "$var". Depending on which runtime configuration flags are active, echo -n can just echo -n instead of suppressing newlines -- and it's perfectly within POSIX specifications to do so! (See in particular the APPLICATION USAGE and RATIONALE sections of pubs.opengroup.org/onlinepubs/9699919799/utilities/echo.html, and note all the uses of "implementation-defined" within that spec). — Charles Duffy
– Charles Duffy, Commented Dec 8, 2020 at 23:00
Similarly, echo "\t" can legally replace that \t with a tab character even without a -e; indeed, doing anything other than printing -e as output when it's passed as an argument violates POSIX, which is part of why bash has runtime-configurable flags to change how echo behaves, so it's at least capable of being made strictly-compliant. — Charles Duffy
– Charles Duffy, Commented Dec 8, 2020 at 23:02

choroba · Accepted Answer · 2020-12-08 22:29:55Z

3

jq '.data[] |= select((."{#PARAMETER}" | length) > 0)' file.json

answered Dec 8, 2020 at 22:29

choroba

245k27 gold badges221 silver badges304 bronze badges

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

3 Comments

hock Over a year ago

When I do this like jq -R -s -c '{data: split("\n") | map({"{#PARAMETER}": (.)}) } | .data[] | select((."{#PARAMETER}" | length) > 0)', jq ignore -c parameter and do output line by line- do you have resolution?

choroba Over a year ago

It doesn't work with -R for me at all. Create a new question to ask a new question.

hock Over a year ago

Ok, I found solution. Problem has been in version 1.5, after download 1.6 it's self resolved. Thanks for help anyway <3

Collectives™ on Stack Overflow

How to remove empty array from Jq in bash script

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related