StringRegExp Help

[Fitgo]

I take this value, in lng: 16.2478996

This is the string:

"bounds" : {
               "northeast" : {
                  "lat" : 39.3137195,
                  "lng" : 16.2478996
               },
               "southwest" : {
                  "lat" : 39.3137169,
                  "lng" : 16.2478815
               }
            },
            "location" : {
               "lat" : 39.3137169,
               "lng" : 16.2478996
            },
            "location_type" : "RANGE_INTERPOLATED",
            "viewport" : {
               "northeast" : {
                  "lat" : 39.3150671802915,
                  "lng" : 16.2492395302915
               },
               "southwest" : {
                  "lat" : 39.3123692197085,
                  "lng" : 16.24654156970849
               }
            }

The value is in here (in lng):

            "location" : {
               "lat" : 39.3137169,
               "lng" : 16.2478996

Let's say "lat" and "lon" can take on any value, just that it is a number with a dot and then another number. Example:

1.31

21.5790

33.12

and more...

[somdcomputerguy]

So what is your question? That may help somebody answer it.

[Fitgo]

I do not know how to take this value: 16.2478996

Is contained in "lng" in "location".

Consists of numbers, a point and then other numbers.

Thanks.

Edited April 15, 2014 by Fitgo

[FireFox]

Hi,

#include <Array.au3>

$s = FileRead("t.txt")

$a = StringRegExp($s, '(?s)"location"(?:.*?)(\d+.\d+),', 3)

_ArrayDisplay($a)

Br, FireFox.

[jdelaney]

This might help:

[mikell]

Firefox,

You've got a typo so you get the lat 

$a = StringRegExp($s, '(?s)"location".*?lng.*?([\d.]+)', 3)

[FireFox]

oh yes, I was going to post the regex to get the lat and the lng until I saw he wanted only the lng.

And thanks for your correction, much better

Edited April 15, 2014 by FireFox

[Fitgo]

#include <Array.au3>

_Restituisci_latitudine("Via Lazio, 36, Cosenza")

Func _Restituisci_latitudine($Indirizzo)
   $oHTTP = ObjCreate("winhttp.winhttprequest.5.1")
   $oHTTP.Open("GET", "http://maps.google.com/maps/api/geocode/json?address=" & $Indirizzo & "&sensor=false")
   $oHTTP.Send()
   $Codice_pagina = $oHTTP.Responsetext

   ; ConsoleWrite($Codice_pagina)

   $Stringa = StringRegExp($Codice_pagina, '(?s)"location"(?:.*?)(\d+.\d+),', 3)
   For $i = 0 To UBound($Stringa) - 1
      Return $Stringa[$i]
   Next
EndFunc

Thank you very much, but I tried that and it does not work.

jdelaney, it seems excessive use external UDF.

[Fitgo]

Thanks but even whit

(?s)"location".*?lng.*?([\d.]+)

it doesn't work.

#include <Array.au3>

_Restituisci_latitudine("Via Lazio, 36, Cosenza")

Func _Restituisci_latitudine($Indirizzo)
   $oHTTP = ObjCreate("winhttp.winhttprequest.5.1")
   $oHTTP.Open("GET", "http://maps.google.com/maps/api/geocode/json?address=" & $Indirizzo & "&sensor=false")
   $oHTTP.Send()
   $Codice_pagina = $oHTTP.Responsetext

   ; ConsoleWrite($Codice_pagina)

   $Stringa = StringRegExp($Codice_pagina, '(?s)"location".*?lng.*?([\d.]+)', 3)
   For $i = 0 To UBound($Stringa) - 1
      Return $Stringa[$i]
   Next
EndFunc

I just need a value so do not know whether it is right to use For... :3

[FireFox]

It does work, and btw you can only make one return.

$s = _Restituisci_latitudine("Via Lazio, 36, Cosenza")

ConsoleWrite("lng : " & $s)

Func _Restituisci_latitudine($Indirizzo)
   $oHTTP = ObjCreate("winhttp.winhttprequest.5.1")
   $oHTTP.Open("GET", "http://maps.google.com/maps/api/geocode/json?address=" & $Indirizzo & "&sensor=false")
   $oHTTP.Send()
   $Codice_pagina = $oHTTP.Responsetext

   ConsoleWrite($Codice_pagina)

   $Stringa = StringRegExp($Codice_pagina, '(?s)"location"(?:.*?)(\d+.\d+),', 3)
   Return $Stringa[0]
EndFunc

Edited April 15, 2014 by FireFox

[mikell]

Confirmation 

#include <Array.au3>

$s = _Restituisci_latitudine("Via Lazio, 36, Cosenza")
_ArrayDisplay($s)

Func _Restituisci_latitudine($Indirizzo)
   $oHTTP = ObjCreate("winhttp.winhttprequest.5.1")
   $oHTTP.Open("GET", "http://maps.google.com/maps/api/geocode/json?address=" & $Indirizzo & "&sensor=false")
   $oHTTP.Send()
   $Codice_pagina = $oHTTP.Responsetext

   Return StringRegExp($Codice_pagina, '(?s)location".*?lat.*?([\d.]+).*?lng.*?([\d.]+)', 3)
EndFunc

You can make one return only but this can be an array 

Edited April 15, 2014 by mikell

[Fitgo]

Very thanks

[Fitgo]

               "lat" : 36.1805194,
               "lng" : -86.72654829999999

Before the number there could also be a hyphen. How do I resolve with:

(?s)location".*?lat.*?([\d.]+).*?lng.*?([\d.]+)

?

Thanks.

[jdelaney]

(?s)location".*?lat.*?([-d.]+).*?lng.*?([-d.]+)

[jchd]

In this context it's unlikely that Google would have fun with you by returning 5-6.7-523...47-5

To remove the possibility of wrong input, use this instead:

(?s)location".*?lat.*?(-?d+(?:.d+)?).*?lng.*?(-?d+(?:.d+)?)