How to use sed to perform a text filter

[PsySc0rpi0n]

Hello...

I need to extract a piece of information out of an output of a previously ran command in my terminal. And this output is in a JSON format, so this is an object wrapped in {} and [] and other chars.
Within those brackets there are several fields which have names and their respective values. Something like the example below:

Code: Select all

Result:
[                   (array of json object)
  {
    "txid" : "txid",
    "vout" : n,
    "address" : "address",
    "label" : "label",
    "scriptPubKey" : "key"
    "amount" : x.xxx,
    "confirmations" : n,
    "redeemScript" : "script"
    "witnessScript" : "script"
    "spendable" : xxx,
    "solvable" : xxx,
    "desc" : xxx,
    "safe" : xxx
  }
  ,...
]

My goal is to extract the value from the field "amount" and send it into my bash script to be stored in a variable a used later.
Can this be one with 'sed', 'awk' or any other way?

[L_V]

For investigation:

Code: Select all

export AMOUNT=`awk '/amount/ { print $3 }' file.json`
echo  $AMOUNT
x.xxx,

[PsySc0rpi0n]

For investigation:

Code: Select all

export AMOUNT=`awk '/amount/ { print $3 }' file.json`
echo  $AMOUNT
x.xxx,

The output I need to filter comes from a previous command. Not from a file.
I mean, I need to run a command that produces an output like the example I posted above in the stdout (terminal window), and from that output I need to filter out the value of that 'amount' field!

[L_V]

The output I need to filter comes from a previous command. Not from a file.

Then, first

Code: Select all

 "a previous command" > file.json

[PsySc0rpi0n]

Ok, thanks...

Although this might be useful, I think I got another work around that might not need to be filtered!

thanks
Psy

[phenest]

Code: Select all

"a previous command" | awk '/amount/ { print $3 }'

[PsySc0rpi0n]

Code: Select all

"a previous command" | awk '/amount/ { print $3 }'

That don't work. It comes out empty! Anyway, don't bother. I have another problem to solve now. I'll create new post, I guess!