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
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT DEBIAN
template::plugin::json::escape
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)