+ Reply to Thread
Results 1 to 1 of 1

Replacing characters withing a URL for a HTTP query using google places api

  1. #1
    Registered User
    Join Date
    05-23-2013
    Location
    Bucharest
    MS-Off Ver
    Excel 2010
    Posts
    14

    Replacing characters withing a URL for a HTTP query using google places api

    Hello

    I have a problem with some names that have spaces, wildcards or other characters like apostrophe '.
    Below are some examples of name and two other links. The links do not work due to the name written using the Concatenate function.

    I need help replacing those characters in the concatenate formula, somehow that Excel recognizes it and the browser also. This is part of a function I wrote, so I need this to become a valid link. The name in question will be in Cell B4 from the concatenate formula.

    =CONCATENATE("https://maps.googleapis.com/maps/api/place/nearbysearch/xml?location=",C4,",",D4,"&radius=200&types=food&name=",B4,"&sensor=false&key=AIzaSyBATWM92nRl-vM87CxNV6gu3WtbU5c_ay8")

    @15 Abchurch Lane Restaurant & Bar
    +65 / Plus-Six-Five Supper Club

    https://maps.googleapis.com/maps/api...es=food&name=6 St Chad's Place&sensor=false&key=AIzaSyBATWM92nRl-vM87CxNV6gu3WtbU5c_ay8

    https://maps.googleapis.com/maps/api...es=food&name=A & G Thompson&sensor=false&key=AIzaSyBATWM92nRl-vM87CxNV6gu3WtbU5c_ay8

    Thanks
    Last edited by Eagle29; 07-25-2013 at 04:40 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 01-30-2014, 03:12 PM
  2. Excel & Google places
    By amail in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-30-2013, 07:51 AM
  3. Web Query # of Google Search Results
    By muckfaster in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-15-2012, 11:27 AM
  4. Http Request Repsonse Query
    By Killavirus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-25-2010, 07:38 PM
  5. Replacing Characters
    By tomyknoker in forum Excel General
    Replies: 4
    Last Post: 09-26-2007, 01:56 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1