Here's a solution for ".. reading values from csv file", using grep and the very handy jq utility:
Code:
grep -i feira cities1000.txt | jq --slurp --raw-input --raw-output 'split("\n") | map(split("\t")) | map({"geonameid": .[0],
"name": .[1],
"asciiname": .[2],
"latitude": .[4],
"longitude": .[5],
"country": .[8],
"population": .[14],
"elevation": .[16] } )'
Result:
Code:
[
{
"geonameid": "3399679",
"name": "Feira Nova",
"asciiname": "Feira Nova",
"latitude": "-7.95083",
"longitude": "-35.38917",
"country": "BR",
"population": "12984",
"elevation": "163"
},
{
"geonameid": "3463478",
"name": "Feira de Santana",
"asciiname": "Feira de Santana",
"latitude": "-12.26667",
"longitude": "-38.96667",
"country": "BR",
"population": "481911",
"elevation": "223"
},
Ciao,
Willem