UNIX and Linux Forums - Search Results

Showing results 1 to 2 of 2 Search took 0.01 seconds. Search: Posts Made By: brlsubbu

Forum: Shell Programming and Scripting 02-15-2018

Sum the fields with 6 decimal places - getting only 2 decimal places as output

3,176

Posted By

awk -F "|" '{a[$2$3$4$5$6$7]+=$8;}END{for(i in...

awk -F "|" '{a[$2$3$4$5$6$7]+=$8;}END{for(i in a)printf "%s|%.6f\n", i, a[i]}' File1

Forum: Shell Programming and Scripting 02-15-2018

Sum the fields with 6 decimal places - getting only 2 decimal places as output

3,176

Posted By

Welcome to the forum. For your problem, try ...

Welcome to the forum.

For your problem, try
awk -F "|" '{a[$2$3$4$5$6$7]+=$8;}END{for(i in a)print i"|"a[i];}' CONVFMT="%.6f" file1
ACCT1 XX 00548 02/13/2018 548JN4 L |18.424000
ACCT2 XY ...

Showing results 1 to 2 of 2