Thanks for the detailed response, and sorry I didn't know about the forum etiquette. I attached a sample data set of 50 observations. In these particular observations, I only see one string I would want to search for: TATA, the rest would be grouped into other. The full data set is about 100,000 rows and grows by about 30,000 rows per month. There are about 500 strings I will want to search for and return String, REPORT_CAT, and Sum of (TRANS_AMOUNT), grouping by REPORT_CAT. All the strings will not be case sensitive, except in the case of EY and TCS which will be case sensitive. Therefore, I will consider TATA to be found if Tata or tata or TAta. I will only consider EY to be found if EY, and TCS to be found if TCS, which are the only two case sensitive strings I will be looking for.
... View more
