Split Google Spreadsheet cell data from Address Map Locator widget

  • Profile Image
    mackenzien
    Asked on August 24, 2015 at 12:57 PM

    Hi!

    I use the Address Map Locator plugin ( currently not working, but can be found here: https://widgets.jotform.com/widget/address_map_locator) on a form.

    When it receives data, it stores it as a string with line breaks (which we store in a GoogleSheet). I was hoping to grab the Latitude and Longitude values from that string and put them each into their own field. Is that possible?

    Thanks!

  • Profile Image
    Mike_G
    Answered on August 24, 2015 at 04:29 PM

    Unfortunately, you cannot separate each line within the form. But, you can separate the data in the Address Map Locator widget column on your Google Spreadsheet.

    Here's how:

    Suppose you already have your form integrated with Google Spreadsheet. 

    On the Google Spreadsheet shown on the image above, we need to separate the data in column E (Address Map Locator widget). 

    First, we need to have additional columns to the right of column E. Since we have 5 data(Address, Country, Province, Latitude and Longitude) that needs to be separated, we will add 5 columns to the right of Address Map Locator widget column.

     

     

    Once you have additional 5 columns to the right, we can now perform the split.

    To do that, click the cell F2, then enter =SPLIT(E2,"")

     

    Now, on the formula that we have entered on cell F2, place your mouse cursor in-between "" and hit ALT+ENTER from your keyboard to set the delimiter as a line break.

    So it should be, =SPLIT(E2,"[ALT+ENTER here]")

    Once you have done that hit enter again to save the formula on cell F2.

    And it should look like this after, 

    Now to copy the formula to each rows of columns F-J, you may refer to this guide: how-to-create-a-formula-for-every-row-in-a-column-in-google-spreadsheet

    I hope this helps. Let us know if you need any further assistance. Thank you.