Looking for assistance with the sed command. I am trying to extract JSON values and assign them to variables using sed. Can someone provide guidance on how this can be achieved?
For example:
echo "{url:news.google.com,int:3}" | sed ?
url=news.google.com
int=3
Here is a suggestion for using the sed command to extract specific information:
url=$(echo "{website:example.com,int:5}" | sed 's/\({\)\([^:]*\)\(:\)\([^,]*\)\(.*\)/\4/')
echo "$url"
example.com
int=$(echo "{website:example.com,int:5}" | sed 's/.*://;s/}//')
echo "$int"
5
It is recommended to use sed only for handling simple JSON structures that you have full control over. For nested or more complex JSONs, jq, Perl, Python and similar tools are a better choice, as mentioned by Sundeep.
Having said that,
echo "{url:news.google.com,int:3}" | sed 's/{//;s/}//;s/:/=/g;s/,/\n/g'
This command will generate the desired output.
Instead of using a specialized JSON parser, you can utilize grep to extract specific data from the given information.
grep -oP 'url:\K[^,}]*'
Here are the test results:
$ echo "{url:news.google.com,int:3}" | grep -oP 'url:\K[^,}]*'
news.google.com
$ echo "{url:news.google.com,int:3}" | grep -oP 'int:\K[^,}]*'
3
\K resets the previously matched dataTo store the extracted value in a variable, you can wrap the command inside $(...) like this:
url=$( echo "{url:news.google.com,int:3}" | grep -oP 'url:\K[^,}]*' )
Alternatively:
$ url=$( grep -oP 'url:\K[^,}]*' <<<"{url:news.google.com,int:3}" )
$ echo $url
news.google.com
Hey there! I'm currently working with an array of JSON objects that looks like this: [{ "senderDeviceId":0, "recipientDeviceId":0, "gmtTimestamp":0, "type":0 }, { "senderDeviceId":0, "recipientDeviceId":0, "gmtTimestamp":0, " ...
Here's a structure that I am working with: [{ "name": "apple", "price": "5.0", "record": [ { "id": "008", "time": 1465689600 } ] },{ "name": "banana", "price": "9.0", "record": [ ...
I've organized my HTML file in the following structure: Chapter 1.1 1.1.1 interesting paragraph 1.1.1.1 interesting paragraph Chapter 1.2 1.2.1 interesting paragraph 1.2.1.1 interesting paragraph ... Chapter 11.4 ... 11.4.12 interesting ...
I have an array variable containing JSON data and I need to update specific values within the array using string keys. Here is a snippet of what my array looks like: { "all": [ { "image":{ "URL":"img/img1.jpeg", ...
I am currently working on a login form that will fetch values from this API: However, the password field is currently empty, allowing any password to be accepted. This results in the error: Failed to compile 'userName' is not defined no-undef; ...
Hey all! I'm currently in the process of building a web application and have chosen Jackson as my JSON processing framework. In terms of the request data I want to send, imagine my POJO structure like this: data class JSONEnvelope( @JsonProp ...
I have exhausted all resources on stack exchange and datatables.net forums trying to solve this issue, but I still can't get it to work. My problem lies with the var listOfFiles, which is a list of the model shown below (List<AudioModel>): pub ...
I'm facing a situation where my Ajax script calls a PHP file to make a query to MySQL and then formats the response in JSON. The challenge is that I need to retrieve data from different tables based on the id sent with the Ajax call. Some tables retur ...
I'm facing a seemingly simple question but I can't seem to figure it out. Below is the jQuery code I am working with: $(function() { $.get(urlGetContainerNumbers, function(data) { console.log(data); for (var idx = 0; idx &l ...
Lately, I have been working on a RESTful API that I recently created. However, knowing myself, I'll probably forget how to use it in a few months. To avoid this, I decided to document my API using Swagger, but little did I know the frustrations that w ...
When attempting to install the npm in an Alpine Linux container, a series of errors occurred during the process. The errors included warnings about preferring global installations, failures with post-install commands, and issues with pre-build tests. $ np ...
I currently have this code snippet in my ASP.Net Web Api project. The resulting data is then sent back to the client. var query = graphClient.Cypher .Start(new { user = userNode.Reference, cultureInfo = startNode.Reference }) ...
Hello, I am trying to extract specific data from a JSON response. Here is the structure of the JSON: { "data":{ "user_quota":[ { "group_limit":10240, "quota":0, "support_share_quota":false, ...
In my table, there is a column with datetimes and corresponding IDs. +----+---------------------+ | id | datetime | +----+---------------------+ | 0 | 2016-09-02 12:13:13 | | 1 | 2016-09-02 10:16:11 | | 2 | 2016-09-05 11:03:23 | | 3 | 2016- ...
When creating a generic ECS service that deals with dynamic data, it is important to note that the containerDefinition within a Task Definition must be provided as a single valid JSON document. The code snippet for this setup looks like: genericClientServi ...
My goal is to have all the keys of an array appear in the first column (Column 0) of an Excel spreadsheet, with the corresponding values populating the rest of the columns in the CSV file (Columns 1-5). Check out the examples below Here is the code I am ...
I have a $response variable that retrieves data from a Square API call. By using var_dump($response), the following output is produced: object(Square\Http\ApiResponse)#26 (8) { ["request":"Square\Http\ApiResponse": ...
When making a YouTube API call, the response includes a var result = JSON.stringify(response, '', 2); that has the following structure: { "kind": "youtube#searchListResponse", "pageInfo": { "totalResults": 1000000, ...
I am currently working on implementing an array of filters to search through a JavaScript object containing store locations. My goal is to find a full match using both filters from the filters array, which currently has 2 items but will eventually have mor ...
When I attempt to parse a JSON-formatted string, a linter error is triggered: let mqttMessage = JSON.parse(message.toString()) // ESLint: Unsafe assignment of an `any` value. (@typescript-eslint/no-unsafe-assignment) Given that I am in control of the con ...