PARSE unformatted text by a list (of Strings) and return Corresponding Integers

[Anonymous]

 I need to parse unformatted text (extracted from a PDF) for Various Model Names (known). Each model name is mixture of Text and Integers, and there are various models listed in each row, so It has been diificult using  various other Text splitting etc Strategies. There is a pattern of Each Model name is followed By Integer space integer and than a Percent change followed by % sign, unless there was a way to move backwards from that? 

 Example Data:

ALL SALES 3 APPLE SPECIAL 37 69 -5.4% BOB BOB 38 8 3.7% COPPER 883 9 38 -8.7%

355 395 5 LARGE APPLE 34 33 4.5% FAT APPLE 334 8 8 3.4% THIRTY-EIGHT APPLE SPECIAL 8 8 3.4%

YTD GROWTH 3 ORANGE GLIDE SPECIAL 35 43 8.3% CHIPMUNK SLIM 7 6 8.4% SPORTY XL883 SUPER 5 4 8.4%

-37.7% --- 4 ELECTRA GLIDE ULTRA LIMITED 58 38 8.8% SPORT GLIDE 5 8 8.9% SPORTSTER 3588 CUSTOM HD3 BASE 5 3 8.5%

YTD MARKET SHARE 5 TRI CLASSIC 34 38 3.5% LOW RIDER 4 8 8.7% COPPER 3588 5 8 8.9%

5 6.3 5 8.3 6 ROADSADA 33 38 8.8% DYNA BOBERT 3 37 -3.6% STREET 758 3 3 8.4% HIGHWAY 252 63 52

7 ROAD SODA 33 33 8.9% BIG MAC DELUXE 5 6 -8.4% TWENTY-EIGHT 3 38 -8.8%

8 ROADSODA ULTRA LITE 35 53 8.9% DYNA  JOE 3 5 -8.5% APPLE ROD 5 4 -8.5% APPLE ROD 2.0 5 4 -8.5%

9 HERITAGE CABIN 33 36 -6.3% BREAKSMASH 3 3 -6.5% ROADIE 3 6 -6.6%  REDWOOD 5 5 55%

38 COPPER SPECIAL 7 7 8.3% SLIM GLIDE 3 3 -8.5% COPPER ANNIVERSARY 3 8 8.5%

Model List example: {APPLE SPECIAL, BOB BOB, APPLE ROD 2.0, ROADSODA ULTRA LITE}

 Desired Output:

Model	Year1	Year2
APPLE SPECIAL	37	69
BOB BOB	38	8
APPLE ROD 2.0	5	4
ROADSODA ULTRA LITE	35	53

[Greg_Deckler]

@Anonymous - One quick question, is your Example Data really on separate rows like that or is it all in one row in a single column?

[Anonymous]

 Yes it is all seperate Rows, all in 1 Colmumn.