Breaking News: Grepper is joining You.com. Read the official announcement!

each transaction is a set 3 records, header body and a trailer in the body record there will be data field of the last 10 bytes

Dizzy Dove answered on January 24, 2022 Popularity 1/10 Helpfulness 1/10

answer each transaction is a set 3 records, header body and a trailer in the body record there will be data field of the last 10 bytes

each transaction is a set 3 records, header body and a trailer in the body record there will be data field of the last 10 bytes

Comment

awk -F'\\|~\\^' '{ 
            if($1=="H"){ 
                head=$0
            }
            else if($1=="T"){
                foot=$1"|~^"$2
                foot4=$4
            }
            else{
                date=$3;
                sub("T.*","", date);
                data[date][NR]=$0;
                sum[date]+=$4; 
                num[date]++
            }
           }
           END{
            for(date in data){
                file=date".txt";
                gsub("-","",file); 
                print head > file; 
                for(line in data[date]){
                    print data[date][line] > file
                } 
                printf "%s|~^%.3f|~^%s|~^%.3f\n", foot, num[date], 
                                              foot4, sum[date] > file
            }
           }' file

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: unix.stackexchange.com

Tags: each field header record set whatever

Link to this answer
Share Copy Link