Search Results

Use 1d; in the sed command.


What does "the output is not in decimal" mean?

It's not that easy, it needs a slightly different approach: not count up and then down a single variable, but sum up first var, then second, and then print both and their difference.
Try and post...

Does your NEW Pay.csv differ from the former Pay1.csv file? I think you might need to use $7 instead of $6, as your Pay1.csv also differs from the sample in post#1.

I presume from the earlier posts that both files are in the working directory. Just remove the /tmp/ in either file path.

Thanks for sharing! How about
awk '
FNR == 1 {next
}
FNR == NR {if (/^Total/) SUM += $2
next
}
{SUM -= $6
...

Please test with the sample data given! Both scripts have been tested on linux and FreeBSD giving a zero variance (or the very small rounding error).