1 vote

How to extract IP address of the host into a row?

=REGEXREPLACE(QUERY(IMPORTDATA("http://xml.utrace.de/?query="&A20), "where Col1 contains 'ip'"), "<ip>|</ip>", "") =INDEX(IMPORTHTML("https://tools.keycdn.com/geo?host="&A20, "...
user0's user avatar
  • 26.4k

Only top scored, non community-wiki answers of a minimum length are eligible