User Agent Format

[Anonymous]

Hi All,

I am writing a report that needs to show responses by Device type an dwe only store the User Agent code e.g.

Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.2; WOW64; Trident/7.0; .NET4.0E; .NET4.0C; InfoPath.2; .NET CLR 3.5.30729; .NET CLR 2.0.50727; .NET CLR 3.0.30729; MSOffice 12)

Does any one out in Power BI land know of a function that can split this string down to show the Device or has any body else had the same problem.

Any help is much appreciated

[v-yulgu-msft]

Hi @Anonymous,

Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.2; WOW64; Trident/7.0; .NET4.0E; .NET4.0C; InfoPath.2; .NET CLR 3.5.30729; .NET CLR 2.0.50727; .NET CLR 3.0.30729; MSOffice 12)

Is above string a sample value of a loaded column? Which part do you want to extract from this string? Please show us your desired result.

Regards,

Yuliana Gu

[Anonymous · Accepted solution]

Hi

The problem is these strings di not have a std format so to determine the device is to say the least hard.

compatible; MSIE 7.0; Windows NT 6.2  in this example the device would be Computer due to the MSIE 7.0

The other prblem is they are random to an extent and there are databases tiy can get to link to.

The reason I asked the question was if any one who had worked with User Agents had worked out a formula to get the device data without a looku p DB.

The more I read about the User Agents it seems a lookup DB may be t he way to go

[Greg_Deckler]

So what part of that string do you want?