iEat2/scripts/weight.jq

#!/usr/bin/jq -Rf

# How to use:
# `scripts/weight.jq usda/WEIGHT.txt`
# That's it.

  split("\n")[]                  # split string into lines
| split("^")                     # split lines int columns
| {                              # format array of columns into jsons
   "ndb_no": .[0] | ltrimstr("~") | rtrimstr("~"),
   "seq": .[1] | tonumber,
   "amount": .[2] | tonumber,
   "msre_desc": .[3] | ltrimstr("~") | rtrimstr("~"),
   "gm_wgt": .[4] | tonumber,
   "num_data_pts": (if (.[5] | length) == 0 then null else .[5] | tonumber end),
   "std_dev": (
     if (.[6] | rtrimstr("\r") | length) == 0 then
       null
     else
       .[6] | tonumber
     end
   )
 }