GD requires Street/City/Region/Country. Tips on how to get it from full address?

This topic contains 1 reply, has 2 voices, and was last updated by  Guust 5 years, 6 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • May 1, 2019 at 7:03 pm #484041

    Directory Path
    Expired Member
    Post count: 235

    Our database has the full address in one column.
    “1600 Amphitheatre Pkwy, Mountain View, CA 94043, USA”

    To import listings in GD, they need to be split into Street/City/Region/Country.

    Any tips on how to do to split the address in the format you need?

    Thank you.

    May 1, 2019 at 10:21 pm #484055

    Guust
    Moderator
    Post count: 29970

    Copy and paste the content of your address column into a text file [notepad].
    Save as a *.csv file.
    Start LibreOffice or OpenOffice and open the file.
    Choose comma delimited.
    You should now have 4 columns.

    Copy and paste the content of the column that has “CA 9404” into a text file [notepad].
    Find and replace all spaces with a comma.
    Save as a *.csv file.
    Start LibreOffice or OpenOffice and open the file.
    Choose comma delimited.
    You should now have 2 columns.

    You now should have the 5 separate columns, and then change CA to California and USA to United States.

    Or use services like https://csv2geo.com/ who will give you this type of data, see attachment.

    Thanks

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount