Extracting Brand table from product list
I have a very large food prodcut list from which I want to create a brand table.
Each Prodcut contains the brand name followed by the product name. There are no separator commas or other dividers. Also brand names can be one or more words.
ARNOLDS FARM MUESLI STRAWBERRY N YOGHURT
ARNOLDS FARM MUESLI TOASTED FARMHOUSE
ARNOTTS ANZAC (10G)
ARNOTTS ARNO SHORTBREAD
ARNOTTS ASSORTED CREAMS
ARNOTTS BRETON REGULAR
MCDONALDS COFFEE CAPPUCCINO SMALL
MCDONALDS SOFT DRINK COCA COLA SMALL
MCDONALDS SOFT DRINK FANTA SMALL
MCDONALDS BURGER DOULBLE BEEF & BACON
HUNGRY JACKS BURGER WHOPPER (269 G)
HUNGRY JACKS BURGER WHOPPER WITH CHEESE (294 G)
HUNGRY JACKS BURGER HAMBURGER (120 G)
We want to extract the brand name (The words that match in the start of the string) and the product name (the rest of the string after the brand name)
I assume I will have to do some clean up after but imagine I can the matching portion of the data from the nonmatching part?
Any help would be greatly appreciated.