Hey all, I've got a file that has a bunch of information. I'm trying to add one of the columns up to give me a total number. The file looks like this.
000099007660060203, New Wave, 80023, with, 14700, labels, 10/07/03, prt8, , printed, 23:29, scanned, 00:28
000099007660060203, New Wave, 80024, with, 335, labels, 10/07/03, prt8, , printed, 23:29, scanned, 00:29
000099007660060203, New Wave, 80019, with, 985, labels, 10/07/03, prt8, , printed, 23:28, scanned, 00:29
000099007660060203, New Wave, 80022, with, 18155, labels, 10/07/03, prt8, , printed, 23:29, scanned, 00:32
000099007660060203, New Wave, 80025, with, 4350, labels, 10/07/03, prt8, , printed, 00:02, scanned, 00:44
000099007660060203, New Wave, 80026, with, 1035, labels, 10/07/03, prt8, , printed, 00:07, scanned, 00:44
000099007660060203, New Wave, 80027, with, 270, labels, 10/07/03, prt8, , printed, 00:36, scanned, 00:45
000099014620052303, New Wave, 80029, with, 330, labels, 10/07/03, prt8, , printed, 04:04, scanned, 04:07
000099011703232000, New Wave, 80502, with, 475, labels, 10/07/03, prt8, , printed, 06:56, scanned, 06:58
000099004693232000, New Wave, 80505, with, 510, labels, 10/07/03, prt8, , printed, 10:04, scanned, 10:06
000099004693232000, New Wave, 80506, with, 580, labels, 10/07/03, prt8, , printed, 10:20, scanned, 10:24
000099011703232000, New Wave, 80507, with, 30610, labels, 10/07/03, prt8, , printed, 11:53, scanned, 12:34
000099011703232000, New Wave, 80508, with, 570, labels, 10/07/03, prt8, , printed, 12:46, scanned, 12:55
000099001403232000, New Wave, 80515, with, 1370, labels, 10/07/03, prt8, , printed, 14:38, scanned, 14:43
000099001403232000, New Wave, 80516, with, 175, labels, 10/07/03, prt8, , printed, 15:19, scanned, 15:20
000099001403232000, New Wave, 80518, with, 450, labels, 10/07/03, prt8, , printed, 15:57, scanned, 16:00
~
I'm trying to add up the 5th field. Is there any way to do this?
000099007660060203, New Wave, 80023, with, 14700, labels, 10/07/03, prt8, , printed, 23:29, scanned, 00:28
000099007660060203, New Wave, 80024, with, 335, labels, 10/07/03, prt8, , printed, 23:29, scanned, 00:29
000099007660060203, New Wave, 80019, with, 985, labels, 10/07/03, prt8, , printed, 23:28, scanned, 00:29
000099007660060203, New Wave, 80022, with, 18155, labels, 10/07/03, prt8, , printed, 23:29, scanned, 00:32
000099007660060203, New Wave, 80025, with, 4350, labels, 10/07/03, prt8, , printed, 00:02, scanned, 00:44
000099007660060203, New Wave, 80026, with, 1035, labels, 10/07/03, prt8, , printed, 00:07, scanned, 00:44
000099007660060203, New Wave, 80027, with, 270, labels, 10/07/03, prt8, , printed, 00:36, scanned, 00:45
000099014620052303, New Wave, 80029, with, 330, labels, 10/07/03, prt8, , printed, 04:04, scanned, 04:07
000099011703232000, New Wave, 80502, with, 475, labels, 10/07/03, prt8, , printed, 06:56, scanned, 06:58
000099004693232000, New Wave, 80505, with, 510, labels, 10/07/03, prt8, , printed, 10:04, scanned, 10:06
000099004693232000, New Wave, 80506, with, 580, labels, 10/07/03, prt8, , printed, 10:20, scanned, 10:24
000099011703232000, New Wave, 80507, with, 30610, labels, 10/07/03, prt8, , printed, 11:53, scanned, 12:34
000099011703232000, New Wave, 80508, with, 570, labels, 10/07/03, prt8, , printed, 12:46, scanned, 12:55
000099001403232000, New Wave, 80515, with, 1370, labels, 10/07/03, prt8, , printed, 14:38, scanned, 14:43
000099001403232000, New Wave, 80516, with, 175, labels, 10/07/03, prt8, , printed, 15:19, scanned, 15:20
000099001403232000, New Wave, 80518, with, 450, labels, 10/07/03, prt8, , printed, 15:57, scanned, 16:00
~
I'm trying to add up the 5th field. Is there any way to do this?