use awk to add/subtract values from a column in csv file

awk -F "," '{printf "%3.6f,%3.6f\n",($1 - 1),$2}' file.txt
This command reads a file called file.txt and then subtracts 1 from the first row. %3.6 is used to format the output columns. The output can be redirected to another file.

Share on Facebook

Tweet