Sum of the field based on the other field values

[Anud]

Hi Team,

how to Sum of the field based on the other field values.
Row1 field values will be 0-9 and a-z.
Sample one given below:

ROW1	ROWcount
11	22
12	54
13	34
a1	56
a2	78
d3	67
c4	78
c5	79

Final Output be like:

ROW1	ROWcount
1	110
a	134
d	67
c	157

Thanks in Advance!!

[richgalloway · Accepted solution]

Here is one of perhaps many ways to do that.  It extracts the first letter of ROW1 as the new ROW1 value and the adds the ROWcount values with matching ROW1 values.

| rex field=ROW1 "(?<ROW1>.)"
| stats sum(ROWcount) as ROWcount by ROW1

[Anud]

Logic was worked. Thank you  so much