Perhaps you could run the following script in batch: #!/usr/bin/awk -f BEGIN \ { FS = ~ accum = 0 } { accum += $3 } END \ { printf( "sum of prices = %d\n", accum) }
> -----Original Message----- > From: Ramya Ramaswamy [mailto:[EMAIL PROTECTED] > Sent: Saturday, August 6, 2005 04:13 PM > To: IBM-MAIN@BAMA.UA.EDU > Subject: SORT help - to split by delimiters > > Hi, > > I have a requirement which states like this: > > Given records like > > 1~ABC~99.99~12345 > 123~AB~9.99~567 > 34~c~1.99~345 > > where there are 4 fields in each record, each separated by a '~'. The third > field is the price field, which i need to sum up. I wont know the starting > position / length of the fields. Is there any way that i can sum up the > price, using Sort or DYL, without having to write a COBOL program using > UNSTRING? > > Thanks in advance, > Ramya > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html