Sponsored Content
Top Forums Shell Programming and Scripting Remove first meta key from json records using shell Post 303028940 by stomp on Friday 18th of January 2019 05:14:26 AM
Old 01-18-2019
I'm the same opinion as Andrew(apmd47). jq is the greatest command line tool for JSON-parsing and manipulation I know. It has a ton of possibilites to mangle / extract json data in this very small binary(<30K). It's written in portable c, with no runtime dependencies. See: jq

Last edited by stomp; 01-18-2019 at 06:22 AM..
These 2 Users Gave Thanks to stomp For This Post:
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Generating key values for leader records

All, I have a file with text as shown below. I want the o/p file with generated values in the first column as shown in the o/p file. Pls note that the size of my file is 6 GB. How do i do this ? Input file 999999abcdef 999999ghijkl 999999mnopq 777777rosesarered 777777skyisblue Output... (1 Reply)
Discussion started by: ajfaq
1 Replies

2. Shell Programming and Scripting

How to delete duplicate records based on key

For example suppose I have a file which contains data as: $cat data 800,2 100,9 700,3 100,9 200,8 100,3 Now I want the output as 200,8 700,3 800,2 Key is first three characters, I don't want any reords which are having duplicate keys. Like sort +0.0 -0.3 data can we use... (9 Replies)
Discussion started by: sumitc
9 Replies

3. Shell Programming and Scripting

How can i use shell meta characters like * ,$ <,> ?

hey guys!! please tell me ...how can i use shell meta characters like * ,$ <,> etc in command line in command line arguments literally please reply soon ..its urgent!!!! (8 Replies)
Discussion started by: tprayush
8 Replies

4. Shell Programming and Scripting

awk - splitting 1 large file into multiple based on same key records

Hello gurus, I am new to "awk" and trying to break a large file having 4 million records into several output files each having half million but at the same time I want to keep the similar key records in the same output file, not to exist accross the files. e.g. my data is like: Row_Num,... (6 Replies)
Discussion started by: kam66
6 Replies

5. UNIX for Advanced & Expert Users

howto remove meta info about MP4 or FLV file downloaded off Youtube?

Hi I tried a tool called mediainfo > brew info media-info media-info 0.7.51 http://mediainfo.sourceforge.net Depends on: pkg-config /usr/local/Cellar/media-info/0.7.51 (3 files, 14M) http://github.com/mxcl/homebrew/commits/master/Library/Formula/media-info.rb Got details from a test... (3 Replies)
Discussion started by: slashdotweenie
3 Replies

6. Shell Programming and Scripting

Removing specific records from files when duplicate key

Hello I have been trying to remove a row from a file which has the same first three columns as another row - I have tried lots of different combinations of suggestion on this forum but can't get it exactly right. what I have is 900 - 1000 = 0 900 - 1000 = 2562 1000 - 1100 = 0 1000 - 1100... (7 Replies)
Discussion started by: tinytimmay
7 Replies

7. Shell Programming and Scripting

Passing key column from parent to child records

Hi Forum. I have this challenging issue that I'm hoping someone can help me. I have a file that contains 3 different types of segments (AM00, AM01, AM32) in a hierarchy structure and I want to be able to pass the column key from the parent record to the children records. AM00 - parent key:... (13 Replies)
Discussion started by: pchang
13 Replies

8. UNIX for Beginners Questions & Answers

Json field grap via shell script/awk

i have a json data that looks like this: { "ip": "16.66.35.10", "hostname": "No Hostname", "city": "Stepney", "region": "England", "country": "GB", "loc": "51.57,-0.0333", "org": "AS6871 British Telecommunications PLC", "postal": "E1" } im looking for a way to assign... (9 Replies)
Discussion started by: SkySmart
9 Replies

9. Shell Programming and Scripting

Remove lines from multiline json

Hi , When extracting the data from API end point ,its giving multi line json .I want to remove certain lines with group": "tag" or tget and respect "item" values python test.py /data{" Id":" 7554317""group":"get", "item":"xx5e1"],"fields":} { "time": 1520460953, "... (4 Replies)
Discussion started by: akil
4 Replies

10. UNIX for Beginners Questions & Answers

How to convert any shell command output to JSON format?

Hi All, I am new to shell scripting, Need your help in creating a shell script which converts any unix command output to JSON format output. example: sample df -h command ouput : Filesystem size used avail capacity Mounted /dev/dsk/c1t0d0s0 8.1G 4.0G 4.0G 50% /... (13 Replies)
Discussion started by: balu1234
13 Replies
Template::Plugin::JSON::Escape(3pm)			User Contributed Perl Documentation		       Template::Plugin::JSON::Escape(3pm)

NAME
Template::Plugin::JSON::Escape - Adds a .json vmethod and a json filter. SYNOPSIS
[% USE JSON.Escape( pretty => 1 ) %]; <script type="text/javascript"> var foo = [% foo.json %]; var bar = [% json_string | json %] </script> or read in JSON [% USE JSON.Escape %] [% data = JSON.Escape.json_decode(json) %] [% data.thing %] DESCRIPTION
This plugin allows you to embed JSON strings in HTML. In the output, special characters such as "<" and "&" are escaped as "uxxxx" to prevent XSS attacks. It also provides decoding function to keep compatibility with Template::Plugin::JSON. FEATURES
USE JSON.Escape Any options on the USE line are passed through to the JSON object, much like "to_json" in JSON. json vmethod A ".json" vmethod converts scalars, arrays and hashes into corresponding JSON strings. [% json_stuct = { foo => 42, bar => [ 1, 2, 3 ] } %] <script> var json = [% json_struct.json %]; </script> <span onclick="doSomething([% json_struct.json %]);"> json filter A "json" filter escapes "<", ">", "&", "+", "U+2028" and "U+2029" as "uxxxx". In the attribute, you may just use an "html" filter. [% json_string = '{ "foo": 42, "bar": [ 1, 2, 3 ] }' %] <script> var json = [% json_string | json %]; </script> <span onclick="doSomething([% json_string | html %]);"> json_decode method A "json_decode" method allow you to convert from a JSON string into a corresponding data structure. [% SET json_struct = JSON.Escape.json_decode(json_string) %] [% json_struct.foo | html %] SEE ALSO
Template::Plugin::JSON, JSON, Template::Plugin VERSION CONTROL
https://github.com/nanto/perl-Template-Plugin-JSON-Escape <https://github.com/nanto/perl-Template-Plugin-JSON-Escape> AUTHOR
nanto_vi (TOYAMA Nao) <nanto@moon.email.ne.jp> COPYRIGHT &; LICENSE Copyright (c) 2011 nanto_vi (TOYAMA Nao). Copyright (c) 2006, 2008 Infinity Interactive, Yuval Kogman. Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. perl v5.14.2 2011-06-13 Template::Plugin::JSON::Escape(3pm)
All times are GMT -4. The time now is 11:28 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy