Calculating number for a specific string length

Sure here is the issue. 

A table we use has column names SSCC which stands for a pallet number. A single row might have multiple pallet numbers separated by comma or by space, and pallet numbers could be from 10 to 13 digits long. 

The below example show product 1 and 2. We can see that product 1 is made up of 3 pallets and product 2 is made of 5 pallets. What is worth nothing is that the pallets are in one cell are sometimes separated by comma and sometimes by space and are 10-13 digits long. 

The output I'd like to get is to put column products in a table and the calculated column with the count of pallets.