parsing - awk to parse csv file -


my input file is:

1601260800434:0:0:0:0:0:157:154:1022:1020:764:765:0:0:0:0:0:0:3:0:0:0:796:223:0:596:168:13247:12178:0 1601260800434:0:0:0:0:0:144:143:1100:1103:914:912:0:0:0:0:0:0:0:0:0:0:822:280:0:715:196:13469:12248:0 1601260815434:0:0:0:0:0:184:178:1005:1006:830:829:0:0:0:0:0:0:2:0:0:0:781:225:0:629:200:13227:12170:0 1601260815434:0:0:0:0:0:182:181:1304:1307:912:914:0:0:0:0:0:0:1:0:0:0:988:317:0:720:193:13537:12330:0 1601260830434:0:0:0:0:0:162:157:1064:1065:873:873:0:0:0:0:0:0:5:0:0:0:846:219:0:705:168:13217:12176:0 1601260830434:0:0:0:0:0:173:168:1273:1273:1004:1002:0:0:0:0:0:0:5:0:0:0:939:332:0:771:229:13531:12328:0

how can have sum per column columns when first field same? 1 total 1601260800434, 1 1601260815434, etc. expect output:

1601260800434:0:0:0:0:0:301:297:2122:2123:1678:1677:0:0:0:0:0:0:3:0:0:0:1618:503:0:1311:364:26716:24426:0 1601260815434:0:0:0:0:0:366:359:2309:2313:1742:1743:0:0:0:0:0:0:3:0:0:0:1769:542:0:1349:393:26764:24500:0 1601260830434:0:0:0:0:0:335:325:2337:2338:1877:1875:0:0:0:0:0:0:10:0:0:0:1785:551:0:1476:397:26748:24504:0

any idea awk code should be? code should take account number of fields/columns. many thanks!

edit: other solution marked possible duplicate not check when first field changes.

awk rescue!

$ awk -f: '{keys[$1]; for(i=2;i<=nf;i++) sums[$1,i]+=$i}         end{for(k in keys)                {printf "%s",k;                 for(i=2;i<=nf;i++) printf "%s", fs sums[k,i];                 print ""                }            }' file 1601260830434:0:0:0:0:0:335:325:2337:2338:1877:1875:0:0:0:0:0:0:10:0:0:0:1785:551:0:1476:397:26748:24504:0 1601260800434:0:0:0:0:0:301:297:2122:2123:1678:1677:0:0:0:0:0:0:3:0:0:0:1618:503:0:1311:364:26716:24426:0 1601260815434:0:0:0:0:0:366:359:2309:2313:1742:1743:0:0:0:0:0:0:3:0:0:0:1769:542:0:1349:393:26764:24500:0

Comments

Post a Comment

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

Image
recently have uploaded wordpress site onto server. have uploaded wordpress site in sub-folder under root folder ../root(domain root folder)/wordpress (where host wordpress folder). now problem content data in page or post in dashboard of wordpress admin panel not showing - see image. but data showing in front view - see image. if not browser cache issue , not issue happened tinymce editor during upgrade; try add config file: define('concatenate_scripts', false);
Read more

How to get the ip address of VM and use it to configure SSH connection dynamically in Ansible -

i trying ip address of vm , trying use establish ssh vm. following script: --- - hosts: localhost become: yes connection: local gather_facts: false serial: 1 vars_files: - createvmvars.yml tasks: - name: gathering vm info. vsphere_guest: vcenter_hostname: "{{vcenter_hostname}}" username: "{{vcenter_username}}" password: "{{vcenter_password}}" guest: "{{guest_name}}" vmware_guest_facts: yes register: var - debug: msg="{{var.ansible_facts.hw_eth0.ipaddresses[0]}}" - name: establishing ssh connection. script: /home/shasha/devops/scripts/ssh_configure.sh "{{var.ansible_facts.hw_eth0.ipaddresses[0]}}" following content of ssh_configure.sh : #!/bin/sh ssh-keygen -t rsa ssh-copy-id $1 but when running playbook, getting following error while executing third task: error! 'var' undefined but debug module(second task) printin
Read more

javascript - Get parameter of GET request -

i make request: createxhrrequest( "get", fileurl, function( err, response ) { if( err ) { alert( "error get!" ); } alert(response); }); and full response: { "status" : "ok", "message" : "jvberi0xljqkjdduxdgkmy how can jvberi0xlj ? i try response.message , response["message"]. nothing works. just simple access this: var json = json.parse(response); json.message
Read more