Convert .txt to json using Shell scripting

Question

I have a text file data.txt:

Framework1,Version1
Framework2,Version2
Framework3,Version3

I need to convert it to data.json which would look like:

[
{"FrameworkName":"Framework1", "VersionName":"Version1"},
{"FrameworkName":"Framework3", "VersionName":"Version2"},
{"FrameworkName":"Framework3", "VersionName":"Version3"}
]

I have tried using awk but it hasn't helped me much. Any help would be appreciated.

What is the data type in txt file? I mean input data type.

Abhijit Pritam Dutta
– Abhijit Pritam Dutta

2018-03-02 11:27:32 +00:00
Commented Mar 2, 2018 at 11:27 — Abhijit Pritam Dutta
– Abhijit Pritam Dutta, Commented Mar 2, 2018 at 11:27

RomanPerekhrest · Accepted Answer · 2018-03-02 15:29:16Z

6

jq solution:

jq -Rs '[ split("\n")[] | select(length > 0) 
          | split(",") | {FrameworkName: .[0], VersionName: .[1]} ]' data.txt

The output:

[
  {
    "FrameworkName": "Framework1",
    "VersionName": "Version1"
  },
  {
    "FrameworkName": "Framework2",
    "VersionName": "Version2"
  },
  {
    "FrameworkName": "Framework3",
    "VersionName": "Version3"
  }
]

https://stedolan.github.io/jq/manual/v1.5/

answered Mar 2, 2018 at 15:29

RomanPerekhrest

93.1k4 gold badges75 silver badges112 bronze badges

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

1 Comment

DimiDak Over a year ago

Lovely... Also output all this to a json file [your above code] > file.json :)

Collectives™ on Stack Overflow

Convert .txt to json using Shell scripting

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related