Did you find any examples on the web? This is the article I was alluding to in my previous post. Also the output of the df command you are using needs to be modified to turn it into something more akin to a CSV file. I would suggest:
as I'm not sure that jq's split function can be used to split on multiple spaces as a single delimiter.
As you have had a go, I'll post a sample based on the above link.
It's not a trivial piece of code, and when I found it I pulled it apart, line by line, until I had an understanding of what is going on.
@NEO, I don't generally do much with JSON, and find JQ is a good tool for pretty-printing, or extracting data from a JSON file. If I wanted to manipulate JSON data, I would probably use python, just as you use PHP.
Hi All,
I have a output like below values
val1=test.com
val2=10.26.208.11
val3=en1
val4=test-priv1.com
val5=192.168.3.4
val6=en2
val7=test-priv2.com
val8=192.168.4.4
val9=en3
val10=test-vip.com
val11=10.26.208.9
val12=$val3
I want to convet this output values into below... (1 Reply)
Friends,
I am trying to convert my local server timezone EST to UTC and for which I used the TZ command, see below
$ date
Thu Dec 6 10:14:14 EST 2012
$
$ TZ=UTC date -d '10:14 EST'
Thu Dec 6 15:14:00 UTC 2012
Now I would like to have the same output in 'yyyymmdd hh:mm' format.
... (4 Replies)
Hello Experts,
Below is the record i have:
sample data attached
I want this record of each row to be in single line and there are multiple rowise unixtime mentioned e.g 11996327 , This needs to be converted to Human readdable data and time from multiple rows
Can you help me , it will be... (10 Replies)
Hello everyone,
I have created a workflow that will pull down data via a RESTful API in JSON, then my code parses and modifies said data. The problem I have is that these APIs I am working with only accept XML to PUT/POST data, and I am looking for an easy way to convert my JSON file to XML.
... (2 Replies)
Hello Everyone,
I have a sample file raw.txt as shown below :
Drive Bays
Bay Name : SD-2C
Number of Standby Power Supplies : 4
Number of Drive Enclosures : 12
Summary Status of Contained Modules
All... (6 Replies)
Dear friends,
I'm getting below API result and i would like to format them with Shell scripting.
Input
"id": 9,
"description": "short desc",
"name": "test",
"name_with_namespace": "ABCD-PDFF-PLATFORM-TEST-V1 / test",
"path": "test",
"path_with_namespace":... (7 Replies)
Hi All,
i am trying to print the solaris 11 packages in below required format, But i am unable to do that.
Current ouput :
root@abc# pkginfo -l | egrep '(BASEDIR|NAME|VERSION)' | awk '{print}'
NAME: QLogic 570x/571x Gigabit Ethernet Driver
VERSION: 11.11,REV=2009.11.11
... (7 Replies)
This is the sample json I have pasted here. I want all the IP address strings to be converted into an array. For example "10.38.32.202" has to be converted to everywhere in the JSON. There are multiple IPs in a JSON I am pasting one sample object from the JSON. But the IPs already in an Array... (11 Replies)
Hi All,
i am trying to print the df -h ouput in json format. using below script.
#!/usr/bin/env bash
df -h > /tmp/sdf
nawk '{print " "$1" "$2" "$3" "$4" "$5" "$6" "}' /tmp/sdf > /tmp/sdf1
nawk 'NR==1 { for (i=1; i<=NF; i++) { f = i }}{ print $(f), $(f), $(f), $(f), ... (2 Replies)
Discussion started by: sravani25
2 Replies
LEARN ABOUT DEBIAN
json_xs
JSON_XS(1p) User Contributed Perl Documentation JSON_XS(1p)NAME
json_xs - JSON::XS commandline utility
SYNOPSIS
json_xs [-v] [-f inputformat] [-t outputformat]
DESCRIPTION
json_xs converts between some input and output formats (one of them is JSON).
The default input format is "json" and the default output format is "json-pretty".
OPTIONS -v Be slightly more verbose.
-f fromformat
Read a file in the given format from STDIN.
"fromformat" can be one of:
json - a json text encoded, either utf-8, utf16-be/le, utf32-be/le
storable - a Storable frozen value
storable-file - a Storable file (Storable has two incompatible formats)
clzf - Compress::LZF format (requires that module to be installed)
yaml - YAML (avoid at all costs, requires the YAML module :)
eval - evaluate the given code as (non-utf-8) Perl, basically the reverse of "-t dump"
-t toformat
Write the file in the given format to STDOUT.
"toformat" can be one of:
json, json-utf-8 - json, utf-8 encoded
json-pretty - as above, but pretty-printed
json-utf-16le, json-utf-16be - little endian/big endian utf-16
json-utf-32le, json-utf-32be - little endian/big endian utf-32
storable - a Storable frozen value in network format
storable-file - a Storable file in network format (Storable has two incompatible formats)
clzf - Compress::LZF format
yaml - YAML
dump - Data::Dump
dumper - Data::Dumper
Note that Data::Dumper doesn't handle self-referential data structures correctly - use "dump" instead.
EXAMPLES
json_xs -t null <isitreally.json
"JSON Lint" - tries to parse the file isitreally.json as JSON - if it is valid JSON, the command outputs nothing, otherwise it will print
an error message and exit with non-zero exit status.
<src.json json_xs >pretty.json
Prettify the JSON file src.json to dst.json.
json_xs -f storable-file <file
Read the serialised Storable file file and print a human-readable JSON version of it to STDOUT.
json_xs -f storable-file -t yaml <file
Same as above, but write YAML instead (not using JSON at all :)
lwp-request http://cpantesters.perl.org/show/JSON-XS.json | json_xs
Fetch the cpan-testers result summary "JSON::XS" and pretty-print it.
AUTHOR
Copyright (C) 2008 Marc Lehmann <json@schmorp.de>
perl v5.14.2 2010-08-17 JSON_XS(1p)