Convert json to csv modifications and variable
Budget: $30 – $250 USD
The purpose is to convert a json to csv with the following modifications:
* Using the value in "contract_decimals" move the decimal in "balance" that many spaces to the left
* Create new field called "percent" and sum the values in "balance" to create a percent of the total balance
* Define new variable (in the sample I used 30000) and multiply this variable by the "percent" for new field called "award"
* Only fields in the sample output should be listed
* Output should be csv
* Bash preferred, if it is faster for you to use different language, let me know in advance
Input and Output sample attached.
* Using the value in "contract_decimals" move the decimal in "balance" that many spaces to the left
* Create new field called "percent" and sum the values in "balance" to create a percent of the total balance
* Define new variable (in the sample I used 30000) and multiply this variable by the "percent" for new field called "award"
* Only fields in the sample output should be listed
* Output should be csv
* Bash preferred, if it is faster for you to use different language, let me know in advance
Input and Output sample attached.
Related categories:
Perl
Business, Accounting, Human Resources & Legal
Shell Script
JSON
Bash Scripting