Concat 2 fields in JSON using jq

I am using jq to reformat my JSON.

JSON String:

{"channel": "youtube", "profile_type": "video", "member_key": "hello"}

Wanted output:

{"channel" : "profile_type.youtube"}

My command:

echo '{"channel": "youtube", "profile_type": "video", "member_key": "hello"}' | jq -c '. | {channel: .profile_type + "." + .member_key}'

I know that the command below concatenates the string. But it is not working in the same logic as above:

echo '{"channel": "youtube", "profile_type": "video", "member_key": "hello"}' | jq -c '.profile_type + "." + .member_key'

How can I achieve my result using ONLY jq?

1

2 Answers

Use parentheses around the string concatenation code:

echo '{"channel": "youtube", "profile_type": "video", "member_key": "hello"}' \ | jq '{channel: (.profile_type + "." + .channel)}' 
1

Here is a solution that uses string interpolation as Jeff suggested:

{channel: "\(.profile_type).\(.member_key)"} 

e.g.

$ jq '{channel: "\(.profile_type).\(.member_key)"}' <<EOF > {"channel": "youtube", "profile_type": "video", "member_key": "hello"} > EOF { "channel": "video.hello" } 

String interpolation works with the \(foo) syntax (which is similar to a shell $(foo) call).
See the official JQ manual.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

You Might Also Like