Clash Royale CLAN TAG#URR8PPP

Create JSON from string with format “key1=value1,key2=value2” using jq

I'm trying to create a json file from a string with the following format:

string="key1=value1,key2=value2"


Is there a way to create a json using jq by specifying the = and , symbols as separators for the keys and values?

=

,

The output I'm looking for would be:

"key1": "value1", "key2” :”value2"


I've tried to use this post as a reference:
Create JSON using jq from pipe-separated keys and values in bash -- however, it expects input that contains a line with only keys, before later lines with only values; here, the keys and values are all interspersed.

2 Answers
2

Here's a reduce-free solution that assumes string is the shell variable (not part of the string to be parsed), and that parsing of the string can be accomplished by first splitting on ",":

string

jq -R 'split(",")
| map( index("=") as $i | (.[0:$i]) : .[$i+1:])
| add' <<< "$string"


Notice that this allows "=" to appear within the values.

The only trickiness here is that when a key name is specified programmatically, it must be enclosed within parentheses.

string="key1=value1|key2=value2,value3|key3=value4"

In this case, you would first split on "|", and then find the first occurrence of "=":

split("|")
| map( index("=") as $i | (.[0:$i]) : .[$i+1:])
| add
| map_values(if index(",") then split(",") else . end)


Output:


"key1": "value1",
"key2": [
"value2",
"value3"
],
"key3": "value4"



string="key1=value1,key2=value2"

jq -Rc '
split(",")
| [. | match( "([^=]*)=(.*)" )]
| reduce ..captures as $item (; .[$item[0].string]=$item[1].string)
' <<<"$string"


By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.