Question

4

Create and append key value pairs to a file of JSON objects with a regex of each JSON object value

rated 0 times [ 4] [ 0] / answers: 1 / hits: 1787 / 1 Year ago, sat, april 29, 2023, 1:50:32

I have a big file that contains json objects each object in a new line.

File example

{"Name" :"%Hana-29-Mrs-Smith","job":"engineer"}

{"Name" :"%Mike-31-Mr-Larry","job":"marketing"}

{"Name" :"%Jhon-40-Mr-Doe","job":"engineer"}

Desired output:

{"Name" :"%Hana-29-Mr-Smith", "f_nams":"Hana", "age":29, "title":"Mrs", "l_name":"Smith","job":"engineer"}

{"Name" :"%Mike-29-Mr-Larry", "f_nams":"Mike", "age":31, "title":"Mr", "l_name":"Larry","job":"marketing"}

{"Name" :"%Jhon-29-Mr-Smith", "f_nams":"Jhon", "age":40, "title":"Mr", "l_name":"Doe","job":"engineer"}

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

atelti

Add To Favorites

Follow

Total Points: 194

Total Questions: 129

Total Answers: 110

Location: North Korea

Member since Tue, Jun 16, 2020

4 Years ago

answered 1 Year ago fulpu · Accepted Answer

For non-nested objects such as this, you could consider using Miller

$ mlr --json put -S '

    @x = splitnv(substr($Name,1,-1),"-"); $f_nams = @x[1]; $age = @x[2]; $title = @x[3]; $l_name = @x[4]

  ' then reorder -e -f job file.json

{ "Name": "%Hana-29-Mrs-Smith", "f_nams": "Hana", "age": 29, "title": "Mrs", "l_name": "Smith", "job": "engineer" }

{ "Name": "%Mike-31-Mr-Larry", "f_nams": "Mike", "age": 31, "title": "Mr", "l_name": "Larry", "job": "marketing" }

{ "Name": "%Jhon-40-Mr-Doe", "f_nams": "Jhon", "age": 40, "title": "Mr", "l_name": "Doe", "job": "engineer" }