iEat2/scripts/nutr_def.jq

#!/usr/bin/jq -Rf

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

  split("\n")[]                  # split string into lines
| split("^")                     # split lines int columns
| {                              # format array of columns into jsons
   "nutr_no": .[0] | ltrimstr("~") | rtrimstr("~") | tonumber,
   "unit": .[1] | ltrimstr("~") | rtrimstr("~"),
   "tagname": .[2] | ltrimstr("~") | rtrimstr("~"),
   "nutr_desc": .[3] | ltrimstr("~") | rtrimstr("~"),
   "num_desc": .[4] | ltrimstr("~") | rtrimstr("~") | tonumber,
   "sr_order": .[5] | ltrimstr("~") | rtrimstr("~\r") | tonumber
 }