blocks|key|143607|text|我推荐使用字符串插值：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|143608|jq+'.users[]+%7C+"\(.first)+\(.last)"'|code-block|syntax|javascript|143609|reference|offset|length|143610|entityMap|0|LINK|mutability|MUTABLE|url|http://stedolan.github.io/jq/manual/#Stringinterpolation-%255C%2528foo%2529^0|0|0|0|9|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

I recommend using String Interpolation:

<pre><code>jq '.users[] | "\(.first) \(.last)"'
</code></pre>

<a href="http://stedolan.github.io/jq/manual/#Stringinterpolation-%5C%28foo%29">reference</a>

blocks|key|139995|text|您可以使用addition来连接字符串。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|139996|139997|+Strings是通过加入一个更大的字符串来添加的。|blockquote|style|BOLD|139998|139999|140000|jq+'.users[]+%7C+.first+%2B+"+"+%2B+.last'|code-block|syntax|javascript|140001|当first和last都是字符串时，上述方法有效。如果你提取不同的数据类型(数字和字符串)，那么我们需要转换成等价的类型。指的是solution+on+this+question。例如。|CODE|140002|jq+'.users[]+%7C+.first+%2B+"+"+%2B+(.number%7Ctostring)'|140003|entityMap|0|LINK|mutability|MUTABLE|url|https://stedolan.github.io/jq/manual/#Addition|1|https://stackoverflow.com/a/46674867/979772^0|5|8|0|0|0|1|7|0|0|0|0|1|5|7|4|1S|P|1|0|0^^$0|@$1|2|3|4|5|6|7|15|8|@]|9|@$A|16|B|17|1|18]]|C|$]]|$1|D|3|-4|5|6|7|19|8|@]|9|@]|C|$]]|$1|E|3|F|5|G|7|1A|8|@$A|1B|B|1C|H|I]]|9|@]|C|$]]|$1|J|3|-4|5|6|7|1D|8|@]|9|@]|C|$]]|$1|K|3|-4|5|6|7|1E|8|@]|9|@]|C|$]]|$1|L|3|M|5|N|7|1F|8|@]|9|@]|C|$O|P]]|$1|Q|3|R|5|6|7|1G|8|@$A|1H|B|1I|H|S]|$A|1J|B|1K|H|S]]|9|@$A|1L|B|1M|1|1N]]|C|$]]|$1|T|3|U|5|N|7|1O|8|@]|9|@]|C|$O|P]]|$1|V|3|-4|5|6|7|1P|8|@]|9|@]|C|$]]]|W|$X|$5|Y|Z|10|C|$11|12]]|13|$5|Y|Z|10|C|$11|14]]]]

You can use <a href="https://stedolan.github.io/jq/manual/#Addition" rel="noreferrer">addition</a> to concatenate strings.

<blockquote>
 Strings are added by being joined into a larger string.
</blockquote>

<pre><code>jq '.users[] | .first + " " + .last'
</code></pre>

The above works when both <code>first</code> and <code>last</code> are string. If you are extracting different datatypes(number and string), then we need to convert to equivalent types. Referring to <a href="https://stackoverflow.com/a/46674867/979772">solution on this question</a>. For example.

<pre><code>jq '.users[] | .first + " " + (.number|tostring)'
</code></pre>

blocks|key|2714902|text|jq+'.users[]%7C.first,.last'+%7C+paste+-+-|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2714903|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>jq '.users[]|.first,.last' | paste - -
</code></pre>

blocks|key|142340|text|除了其他人的建议之外，我认为有两个选择值得一提。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|142341|打印为CSV/TSV|142342|$+cat+file.json+%7C+jq+-r+'.users[]+%7C+[.first,+.last]+%7C+@tsv'
Stevie++Wonder
Michael+Jackson|code-block|syntax|javascript|142343|cat+file.json+%7C+jq+-r+'.users[]+%7C+[.first,+.last]+%7C+@csv'
"Stevie","Wonder"
"Michael","Jackson"|142344|第一个表达式.users[]将对象从最外层的数组中取消嵌套，如问题中给出的代码所示。下一个表达式[.first,+.last]为每个输入对象创建一个新的值数组，最后一个表达式使用内置函数@tsv和@csv分别将所有输入数组打印为制表符分隔值和逗号分隔值。|offset|length|style|CODE|142345|打印为JSON值|142346|类似地，可以再次构造JSON值，如果您只想保留字段的一个子集，这是很有趣的：|142347|$+cat+file.json+%7C+jq+-c+'.users[]+%7C+{first}'
{"first":"Stevie"}
{"first":"Michael"}|142348|entityMap^0|0|0|0|0|6|8|1C|F|2L|4|2Q|4|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|F|7|11|8|@]|9|@]|A|$G|H]]|$1|K|3|L|5|6|7|12|8|@$M|13|N|14|O|P]|$M|15|N|16|O|P]|$M|17|N|18|O|P]|$M|19|N|1A|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1B|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1C|8|@]|9|@]|A|$]]|$1|U|3|V|5|F|7|1D|8|@]|9|@]|A|$G|H]]|$1|W|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|X|$]]

In addition to what others have suggested, I think that two options are worth mentioning.
<h3>Print as CSV/TSV</h3>
<pre class="lang-sh prettyprint-override"><code>$ cat file.json | jq -r '.users[] | [.first, .last] | @tsv'
Stevie Wonder
Michael Jackson
</code></pre>
<pre class="lang-sh prettyprint-override"><code>cat file.json | jq -r '.users[] | [.first, .last] | @csv'
&quot;Stevie&quot;,&quot;Wonder&quot;
&quot;Michael&quot;,&quot;Jackson&quot;
</code></pre>
The first expression, <code>.users[]</code>, unnests the objects from the outer-most array as in the code given in the question. The next expression, <code>[.first, .last]</code>, creates a new array of the values for each input object, and the final expression uses the built-in functions <code>@tsv</code> and <code>@csv</code> to print all input arrays as tab-separated and comma-seperated values, respectively.
<h3>Print as JSON values</h3>
Similarly, it is possible to construct JSON values again, which is interesting if you just want to keep a subset of the fields:
<pre class="lang-sh prettyprint-override"><code>$ cat file.json | jq -c '.users[] | {first}'
{&quot;first&quot;:&quot;Stevie&quot;}
{&quot;first&quot;:&quot;Michael&quot;}
</code></pre>

blocks|key|2927687|text|我的方法是(您的json示例格式不正确..(我猜那只是一个样本)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2927688|jq+'.Front[]+%7C+[.Name,.Out,.In,.Groups]+%7C+join("%7C")'++front.json++>+output.txt|code-block|syntax|javascript|2927689|返回如下所示的内容|2927690|"new.domain.com-80%7C8.8.8.8%7C192.168.2.2:80%7C192.168.3.29:80+192.168.3.30:80"
"new.domain.com+-443%7C8.8.8.8%7C192.168.2.2:443%7C192.168.3.29:443+192.168.3.30:443"|2927691|并使用正则表达式对输出进行grep。|2927692|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

my approach will be (your json example is not well formed.. guess thats only a sample)

<pre><code>jq '.Front[] | [.Name,.Out,.In,.Groups] | join("|")' front.json &gt; output.txt
</code></pre>

returns something like this 

<pre><code>"new.domain.com-80|8.8.8.8|192.168.2.2:80|192.168.3.29:80 192.168.3.30:80"
"new.domain.com -443|8.8.8.8|192.168.2.2:443|192.168.3.29:443 192.168.3.30:443"
</code></pre>

and grep the output with regular expression.

blocks|key|143616|text|当key和value是字符串时，上面的两个答案都能很好地工作，但我遇到了附加字符串和整数的情况(使用上面的表达式出现了jq错误)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|143617|需求:在json下面构造一个url|143618|pradeep@seleniumframework>curl+http://192.168.99.103:8500/v1/catalog/service/apache-443+%7C+jq+.[0]
++%25+Total++++%25+Received+%25+Xferd++Average+Speed+++Time++++Time+++++Time++Current
+++++++++++++++++++++++++++++++++Dload++Upload+++Total+++Spent++++Left++Speed
100+++251++100+++251++++0+++++0+++155k++++++0+--:--:--+--:--:--+--:--:--++245k
{
++"Node":+"myconsul",
++"Address":+"192.168.99.103",
++"ServiceID":+"4ce41e90ede4:compassionate_wozniak:443",
++"ServiceName":+"apache-443",
++"ServiceTags":+[],
++"ServiceAddress":+"",
++"ServicePort":+1443,
++"ServiceEnableTagOverride":+false,
++"CreateIndex":+45,
++"ModifyIndex":+45
}|code-block|syntax|javascript|143619|解决方案：|143620|curl+http://192.168.99.103:8500/v1/catalog/service/apache-443+%7C
jq+'.[0]+%7C+"http://"+%2B+.Address+%2B+":"+%2B+"\(.ServicePort)"'|143621|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

While both of the above answers work well if key,value are strings, I had a situation to append a string and integer (jq errors using the above expressions) 

Requirement: To construct a url out below json

<pre><code>pradeep@seleniumframework&gt;curl http://192.168.99.103:8500/v1/catalog/service/apache-443 | jq .[0]
 % Total % Received % Xferd Average Speed Time Time Time Current
 Dload Upload Total Spent Left Speed
100 251 100 251 0 0 155k 0 --:--:-- --:--:-- --:--:-- 245k
{
 "Node": "myconsul",
 "Address": "192.168.99.103",
 "ServiceID": "4ce41e90ede4:compassionate_wozniak:443",
 "ServiceName": "apache-443",
 "ServiceTags": [],
 "ServiceAddress": "",
 "ServicePort": 1443,
 "ServiceEnableTagOverride": false,
 "CreateIndex": 45,
 "ModifyIndex": 45
}
</code></pre>

Solution:

<pre><code>curl http://192.168.99.103:8500/v1/catalog/service/apache-443 |
jq '.[0] | "http://" + .Address + ":" + "\(.ServicePort)"'
</code></pre>

blocks|key|2714898|text|这将生成一个名称数组|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2714899|>+jq+'[+.users[]+%7C+(.first+%2B+"+"+%2B+.last)+]'+~/test.json

[
++"Stevie+Wonder",
++"Michael+Jackson"
]|code-block|syntax|javascript|2714900|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This will produce an array of names

<pre><code>&gt; jq '[ .users[] | (.first + " " + .last) ]' ~/test.json

[
 "Stevie Wonder",
 "Michael Jackson"
]
</code></pre>

blocks|key|2714893|text|通过这样做，我非常接近我想要的东西。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2714894|cat+my.json+%7C+jq+'.my.prefix[]+%7C+.primary_key+%2B+":",+(.sub.prefix[]+%7C+"++++-+"+%2B+.sub_key)'+%7C+tr+-d+'"'+|code-block|syntax|javascript|2714895|它的输出足够接近yaml，我通常可以将其导入到其他工具中，而不会有太多问题。(我仍然在寻找一种方法来基本导出输入json的子集)|2714896|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I got pretty close to what I wanted by doing something like this

<pre><code>cat my.json | jq '.my.prefix[] | .primary_key + ":", (.sub.prefix[] | " - " + .sub_key)' | tr -d '"' 
</code></pre>

The output of which is close enough to yaml for me to usually import it into other tools without much problem. (I am still looking for a way to basicallt export a subset of the input json)

I have this Json
<pre><code>{
 &quot;users&quot;: [
 {
 &quot;first&quot;: &quot;Stevie&quot;,
 &quot;last&quot;: &quot;Wonder&quot;
 },
 {
 &quot;first&quot;: &quot;Michael&quot;,
 &quot;last&quot;: &quot;Jackson&quot;
 }
 ]
}
</code></pre>
Using jq I'd like to display first and last name serially. Like so -
<pre><code>Stevie Wonder
Michael Jackson
</code></pre>
This is how far I have gotten -
<pre><code>jq '.users[].first, .users[].last'
</code></pre>
But it displays
<pre><code>&quot;Stevie&quot;
&quot;Michael&quot;
&quot;Wonder&quot;
&quot;Jackson&quot;
</code></pre>
Notice the following:
<ol>
<li>The double quotes that I do not want.</li>
<li>The carriage return that I do not want.</li>
<li>It's jumbled up. My query displays all the first names first, and then all the last names. However, I want first-last, first-last pair.</li>
</ol>

Using jq to parse and display multiple fields in a json serially

JSON

我有这个Json{    "users": [        {            "first": "Stevie",            "last": "Wonder"        },        {            "first": "Michael",            "last": "Jackson"        }    ]}使用jq，我想连续显示名字和姓氏

问使用jq串行解析和显示json中的多个字段
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用jq串行解析和显示json中的多个字段EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用jq串行解析和显示json中的多个字段
EN