Parsing user agent strings

[esuriency]

Is there a macro or module out there that would parse agent strings? Just looking for Device Type, Operating System, Browser.
For example:
Mozilla/5.0 (iPad; CPU OS 9_3_5 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13G36 Safari/601.1
Tablet, iOS 9.3.5, Safari Mobile 9.0

 

[Gerald Higgins]

Give us some examples of what the inputs are, and what the outputs should be.

 

[esuriency]

There's so many variations (see examples here) and I don't see any consistent patterns to them.

Example Input and Outputs

Source Data	OS (Output)	Browser (Output)
Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.90 Safari/537.36	Windows 10	Chrome 60
Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko	Windows 10	Internet Explorer 11
Mozilla/5.0 (iPad; CPU OS 9_3_5 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13G36 Safari/601.1	Mac OS iPad	Safari 9

<tbody>
</tbody>

 

[Gerald Higgins]

Well that's a problem then.

If there is no consistent pattern, I don't see how anyone can write a formula or programme to do this job.

You could perhaps store all your target values in a range somewhere, and then test whether each input contains ANY of the target values, but that's a bit complicated.

And maybe more so, given that some of your outputs don't seem to even be in the input values.
For example, in entry 1, is the solution supposed to recognise that "Windows NT 10.0" is the same as "Windows 10" ?
For example, in entry 1, is the solution supposed to recognise that "Chrome/60" is the same as "Chrome 60", or maybe any instance of "Chrome" should be identified as "Chrome 60" ?
For example, in entry 2, how do we identify Internet Explorer 11 ?
For example, in entry 3, how do we identify Safari 9 ?

The answers to the above may be obvious to you, but we need to devise a systematic way of working out the answers, and you need to help us on how to do that exactly.