separate the last digit, detect the quantity in each of the 4 patterns

[jack]

separate the last digit, detect the quantity in each of the 4 patterns
https://www.mediafire.com/file/geoodnq01xml2yf/4+padroes.xlsx/file