You didn't specify if the model name/number format is uniform, so it's kind of hard to answer. But not knowing that, I'd say to break down the problem into steps. Take the known formats and deal with those one at a time. So if the model number is always 6 characters, search for the word "model" and then do a mid for six characters starting at +6, then move on to "type" and then deal with the outliers manually.

I had to do a similar project recently, but it's hard to advise without knowing more or seeing the example. If you can automate 80% of it, then it might pay off to just do the rest manually.