Hi, im trying to carry out an awk command to get the total sum of a file but need the 0's before the number to be included.

File (totals.txt)
0000000000000062.88
0000000000000110.14
0000000000000059.44
0000000000000051.09
0000000000000136.57
0000000000000203.28
0000000000000042.84
0000000000000729.02
0000000000000039.55
0000000000000030.95
0000000000000087.44
0000000000000028.98

the best i can do is the following:

awk '{ sum += $1 } END { print sum }' totals.txt

output:
1582.18

whereas i need it to come back as 0000000000001582.18

any ideas or help would be greatly appreciated,

Thanks

Hi and welcome to LinuxQuestions!

You can try printf and specify the desired format:
If you want to retrieve the format from the input, it's a little more tricky but doable.

2 members found this post helpful.

Colucix,

That is exactly what i needed!

Thanks a million

Always comes with good solution. May you merit as much prosperity as you have done good to others in need.

Although I was not the one who solicited help, never the less I say, thank you.

Thank you, malekmustaq! Really appreciated.

You both are welcome!