Extract Lat and Long from a Google URL keep in csv file

[mrbajana]

I have a text file with a column that has thousands of records with the google links maps as I show it below:

https://www.google.com/maps/place/2%C2%B003'02.4%22S+79%C2%B054'42.5%22W/@-2.0506784,-79.9139984,17z/data=!3m1!4b1!4m5!3m4!1s0x0:0x0!8m2!3d-2.0506784!4d-79.9118097?hl=es

In some links there is a different position.

How do I extract the latitude and longitude of that link?

Marco

[v-danhe-msft · Accepted solution]

Hi @mrbajana,

Based on my test, you could refer to below steps in query editor:

Spilt the column by "@"

Split the new column by "/"

Split the new column by "," and remove the other columns. Now you could get the result.

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/49axqs7xhhm7725/Extract%20Lat%20and%20Long%20from%20a%20Google%20URL%20kee...

Regards,

Daniel He

[mrbajana]

Thanks Daniel Hes

It Works!!!