Convert String to JSON in bash

Question

I have a string which is formated as a long string (no newlines) like so:

<NAME1>ID1>CODE1a>CODE1b>><NAME2>ID2>CODE2a>CODE2b>><NAME3>ID3>CODE3a>CODE3b>>

The idea is convert this string to JSON:

{
  "ID1": [
    "NAME1",
    "CODE1a",
    "CODE1b"
  ],
  "ID2": [
    "NAME2",
    "CODE2a",
    "CODE2b"
  ],
  "ID3": [
    "NAME3",
    "CODE3a",
    "CODE3b"
  ]
}

The question is I need that in one comand (something like cat testfile.txt | sed "..." | tr "...")

I've tried to use sed, tr, jq, but no success, and I'm completely stuck. Thanks in advance

peak · Accepted Answer · 2020-04-12 01:52:56Z

1

The whole thing can be done using just jq, e.g.:

jq -R '
  sub("^<";"")
  | split(">><")
  | map(split(">"))
  | map( { (.[1]) : (.[0:1] + (.[2:] | map(select(.!="")))) } )
  | add
'

edited Apr 12, 2020 at 1:52

answered Apr 11, 2020 at 4:25

peak

119k21 gold badges185 silver badges218 bronze badges

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

4 Comments

Filipe Pires Over a year ago

It is getting error: tio.run/…

peak Over a year ago

Sorry - there was a typo. Fixed.

Filipe Pires Over a year ago

Perfect! I'll accept this one as the answer, because it's only using jq, although the other one does the job also! Just one question, how is used the split function and why did you have (wrongly) the two args?

peak Over a year ago

split(STRING) splits the input string at STRING, producing an array. (See the manual regarding the difference between split and splits.) As for the typo - the original version I developed had a call to gsub(_;_) and I incorrectly edited it.

Collectives™ on Stack Overflow

Convert String to JSON in bash

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related