AnsweredAssumed Answered

Extracting Brand table from product list

Question asked by brettpix on Sep 28, 2012
Latest reply on Sep 28, 2012 by LaRetta_1

Title

Extracting Brand table from product list

Post

     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.

     eg

     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.

      

     Kind regards

     Brett

Outcomes