#!/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 }