Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alecwh22
Starting Member
15 Posts |
 Posted - 2012-05-18 : 09:26:25
|
| I have a large amount of user agent data and just as a string its pretty useless so I want to break it up into its components. has anyone else done something like this before that I could use as a starting block?cheers alecwh22Note: I understand this is a big task and if you don't want to share your hard work I understand but some pointers would be much appreciated. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-05-18 : 09:45:34
|
| You can probably parse it fairly easily, it's not secret information, it's just not something well suited to SQL.If you can post some sample data we can get started on it. 10-20 rows is fine, and please show the output you want to achieve. |
 |
|
|
|
|
|
decode useragent