Скачать или смотреть How to Extract and Print Values from a JSON-Like Structure in Linux Using jq

Learn how to efficiently extract values from a string by utilizing `sed` and `jq` in Linux. This guide provides a step-by-step solution for handling JSON-like data in a simple and clear manner.
---
This video is based on the question https://stackoverflow.com/q/75877542/ asked by the user 'Surendar' ( https://stackoverflow.com/u/11709330/ ) and on the answer https://stackoverflow.com/a/75877819/ provided by the user 'Ed Morton' ( https://stackoverflow.com/u/1745001/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Print the result of string after a particular key word

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Extract and Print Values from a JSON-Like Structure in Linux Using jq

In many scenarios when working with data processing in Linux, you might encounter a formatted string that contains key information embedded within it. For instance, you may have a JSON-like structure but need to extract particular values, such as names and emails, for further analysis or reporting.

In this guide, we will explore how you can use the sed command alongside jq to transform the input data into a format from which you can easily retrieve the desired results.

The Challenge

Consider you have the following sample text file that contains JSON-like records:

[[See Video to Reveal this Text or Code Snippet]]

You want to extract the ma-name and emailID values and print them alongside one another in an organized manner:

Expected Output

[[See Video to Reveal this Text or Code Snippet]]

The Solution

To achieve this, we can take advantage of two powerful command-line tools: sed and jq. Below, we'll break down the process step by step.

Step 1: Transforming Input Data

First, we need to modify the input data to make it suitable for processing with jq. The sed command is perfect for this job. The following command surrounds each line with square brackets to convert it into a valid JSON array:

[[See Video to Reveal this Text or Code Snippet]]

Where file is the name of your text file.

Step 2: Using jq to Extract Values

Once the data is JSON-formatted, we can pipe it into jq to extract the ma-name and emailID. The following command achieves that:

[[See Video to Reveal this Text or Code Snippet]]

This command does the following:

-r: Enables raw output, which prevents double quotes from being included around the output.

.[]: Iterates through each record in the JSON array.

" ": Concatenates the ma-name and emailID with a space in between for better readability.

Complete Command

You can combine both commands for a one-liner that processes your input efficiently:

[[See Video to Reveal this Text or Code Snippet]]

Final Output

When you run this command, you will achieve the desired output:

[[See Video to Reveal this Text or Code Snippet]]

Conclusion

Using sed and jq, you can easily manipulate and extract required information from a JSON-like string in Linux. This method is not only efficient but also scalable for larger datasets.

Now that you have this knowledge, you can apply it to various situations where data extraction and manipulation are required. Try experimenting further with more complex fields or additional data formats to deepen your understanding of these tools.

Happy scripting!