Sponsored Content
Full Discussion: JSON Output format
Top Forums Shell Programming and Scripting JSON Output format Post 303034682 by stomp on Thursday 2nd of May 2019 08:47:10 AM
Old 05-02-2019
Hi,

jq is an incredible JSON-tool. Here's a primer to start from:

Code:
script_producing_json | jq -r '.[] | [ (.id|tostring), .description, .path, .last_activity_at ] | join(" | ") '

# output:

9 | short desc | test | 2019-02-25T10:25:29.771Z
6 |  | test | 2019-02-21T07:44:14.083Z
4 | Who | applabonboarding | 2019-02-19T13:17:22.321Z

See: Stedolan jq

Hint: Have in mind, that a problem can get way to complex so that shell may not be an appropriate tool for the task and a decent scripting language(python, ruby,...) may serve you much better.

Last edited by stomp; 05-02-2019 at 11:03 AM..
These 2 Users Gave Thanks to stomp For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

capturing output from top and format output

Hi all, I'd like to capture the output from the 'top' command to monitor my CPU and Mem utilisation.Currently my command isecho date `top -b -n1 | grep -e Cpu -e Mem` I get the output in 3 separate lines.Tue Feb 24 15:00:03 Cpu(s): 3.4% us, 8.5% sy .. .. Mem: 1011480k total, 226928k used, ....... (4 Replies)
Discussion started by: new2ss
4 Replies

2. Shell Programming and Scripting

Help in Getting specified output format

Hi all, I have input text file of this format objectclass:endeavor pid:12345 postalAddress:379 PROSPECT ST street:STE B l:TORRINGTON st:CT postalCode:067905238 telephoneNumber:9999999999... (2 Replies)
Discussion started by: pintoo
2 Replies

3. UNIX for Advanced & Expert Users

format df -k output

i am running df -k command on aix machine. i got the output like this. i need to store into file and send that file into microsoft excel.i need to allign properly. Filesystem 512 blocks Free % Used Iused %Iused Mounted on /dev/hd4 262144 126488 52% ... (9 Replies)
Discussion started by: wintercoat
9 Replies

4. Shell Programming and Scripting

Dynamic output file generation using a input text file with predefined output format

Hi, I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format. Example: File.txt AP|{SSHA}VEEg42CNCghUnGhCVg== APVG3|{SSHA}XK|"password" AP3|{SSHA}XK|"This is test" .... etc --------- test.sh has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies

5. Shell Programming and Scripting

perl code-sequence of json format

Hi All , Below is the perl code. from below code want to confirm one thing that wahtever the sequence of data we are passing through json format which contains 3 tuples of different sequences Eg: ParentID,SystemID,SendingTime,Time,ClientLocation,ClientID, ... (1 Reply)
Discussion started by: aish11
1 Replies

6. UNIX for Dummies Questions & Answers

How to format the output of df -h?

Hi, I need to format the output of the command "df -h": $ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/rootvg-lv01 271G 13G 245G 6% / tmpfs 16G 0 16G 0% /dev/shm /dev/sda1 97M 50M 43M 55% /boot /dev/mapper/d1vg-lv01 124G 105G 13G 90% /d0 I used awk: df -h |... (6 Replies)
Discussion started by: seafan
6 Replies

7. Shell Programming and Scripting

FORMAT output

Input File Symmetrix ID : 000192601507 Masking View Name : TS00P22_13E_1 Last updated at : 05:10:18 AM on Tue Mar 22,2011 Initiator Group Name : 10000000c960b9cd Host Initiators { WWN : 10000000c960b9cd WWN : 10000000c960b9dd } Port... (1 Reply)
Discussion started by: greycells
1 Replies

8. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

9. UNIX for Beginners Questions & Answers

Printing df -h output in json format

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

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
Test::BDD::Cucumber(3pm)				User Contributed Perl Documentation				  Test::BDD::Cucumber(3pm)

NAME
Test::BDD::Cucumber - Feature-complete Cucumber-style testing in Perl VERSION
version 0.11 DESCRIPTION
A sane and complete Cucumber implementation in Perl QUICK LINKS
Cucumber on Perl on MetaCPAN <https://metacpan.org/release/Test-BDD-Cucumber> WARNING
This is beta software, at best. The interface is unlikely to undergo major incompatible changes, but it's certainly possible. Do have a read of the Bugs and Missing section below so you're not surprised when these things don't work. In almost all cases, where the behaviour of this module is different from the real Cucumber, the plan is to move it to be more similar to that. The idea is that the first 1.0 release will be the first production release and before that, you're on your own. There are many things still to add, but I'm using it to do Real Things already. NEXT STEPS
If you are completely new to Cucumber, you'd get a pretty overview from reading our short and crunchy Tutorial. If you already understand Cucumber, and just want to get started then you should read the Step-writing quick-start guide, the documentation for our command-line tool App::pherkin, and How to integrate with Test::Builder. If you want to extend or integrated Test::BDD::Cucumber then you'd probably be more interested in our Architecture overview. TEN SECOND GUIDE TO USING THIS IN YOUR CI ENVIRONMENT
Don't use the command-line tool, App::pherkin. Instead, look at the How to integrate with Test::Builder document. BUGS, MISSING, AND LIMITATIONS The following things do not work in this release, although support is planned in the very near future: o Localization o Step Argument Transforms o Quoting in tables is broken o Placeholders in pystrings is broken o Explicit Step Outline notation doesn't work (although step outlines are explicitly supported) o Unicode support is probably a bit ropey o Pherkin isn't really fit for purpose yet CODE
On Github, of course: https://github.com/sheriff/test-bdd-cucumber-perl <https://github.com/sheriff/test-bdd-cucumber-perl>. AUTHOR
Peter Sergeant "pete@clueball.com" LICENSE
Copyright 2011, Peter Sergeant; Licensed under the same terms as Perl perl v5.14.2 2012-05-20 Test::BDD::Cucumber(3pm)
All times are GMT -4. The time now is 01:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy