ETL: BrowserFullName

Extract the full browser name and version string from a user agent string using ua_parser. Use for web analytics in ETL data pipelines.

Description

Extract browser family (name) and version from user agent string, based on ua_parser.

Syntax

BrowserFullName(user_agent_string)

Examples

BrowserFullName('Mozilla/5.0 (Macintosh; Intel Mac OS X 10_6_8) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.93 Safari/537.36') returns ‘Chrome 27.0.1453’

Return value datatype

string

Notes

Returns ‘other’ if browser family and version can’t be extracted from string.

Impact of null value

If input is null, returns null.