Hi Candee, I can't test this at the minute, but if you change the 0 to 1 in the first extract_token, does it return the version?
Tony On 5 Jun 2015 14:30, "Candee" <[email protected]> wrote: > Does anyone use LPS 2.2 and create your own queries? > I'm trying to create a query to select substrings from cs-useragent. > I started with their query ActiveSync: Apple Device/iOS Version Report. > Instead of adding a kazillion lines to it I thought it would be easier to > pull just the version numbers - ie: 1206.70 = 8.3 > > "CASE EXTRACT_TOKEN(cs(user-agent),0,'/') > This works to get "Apple-iPhone7C2" > Out of: 'Apple-iPhone7C1/1202.440' > > I'm trying to get the second part "1202.440" > I tried CASE EXTRACT_TOKEN(cs(user-agent,'/',0) but get an error that the > second part has to be an integer > > Any help appreciated. > Thanks all. > Candee >
