Is there a way to count the number of letters until you get to a number? For instance:
Coke 12pk Can
Diet Coke 6pk Can
Cherry Coke 6pk Can
Coke 6pk Can
I need to do a brand breakdown, by summing totals for each brand such as Coke, Diet Coke, Cheery Coke etc...
Some brands have 3 words, some have 2 words, the only similarities is the Brand name ends at the first number, is there a way to count the letters up to the number?
Thanks in advance