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

Question

I have this Json         users                            first    Stevie                last    Wonder                                    first    Michael                last    Jackson                      Using jq I d like to display first and last name serially  Like so -   Stevie Wonder Michael Jackson   This is how far I have gotten -   jq   users   first   users   last    But it displays   Stevie   Michael   Wonder   Jackson    Notice the following -   The double quotes that I do not want  The carriage return that I do not want  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

User · Answer

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

pradeep@seleniumframework>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
}

Solution:

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

User · Answer

my approach will be  your json example is not well formed   guess thats only a sample   jq   Front       Name  Out  In  Groups    join        front json   gt  output txt   returns something like this    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    and grep the output with regular expression

User · Answer

jq   users    first  last    paste - -

User · Answer

I got pretty close to what I wanted by doing something like this  cat my json   jq   my prefix      primary key          sub prefix          -      sub key     tr -d        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

User · Answer

I recommend using String Interpolation   jq   users         first     last      reference

User · Answer

You can use addition to concatenate strings      Strings are added by being joined into a larger string    jq   users      first          last    The above works when both first and last are string  If you are extracting different datatypes number and string   then we need to convert to equivalent types  Referring to solution on this question  For example   jq   users      first           number tostring

User · Answer

This will produce an array of names   gt  jq     users       first          last       test json       Stevie Wonder      Michael Jackson

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

Examples related to json

Examples related to jq