I’m using the new google integration to auto complete addresses then sending them over to shipstation via webhook. However, shipstation requires individual address fields such as street, city, state, zip, etc… Is there any way I can extract the required parts of this single complete address column …

Is the address in a reliably consistent format? Do you have some fake example addresses that follow the format you currently have? Include any variations (street names vs numbers, addition directional indicators such as 12th St N, any with apartment numbers, etc) Also, does the street include hou…

The addresses are standard: 123 Street Name Apartment X, City Name, State 55555, USA Some include a unit/apt #, some follow the example you gave.

Do you always have the country at the end? I wasn’t accounting for that. The ChatGPT solution wasn’t panning out to my liking, so I started from scratch. This is what I have so far. You can place it into a javascript column and pass the address into the p1 parameter. I’m sure it needs several a…

@Jeff_Hager this is a great solution. What if I only want to pull out the City from the address, what edits would I make to this script? I’ve tried editing this myself but my lack of JS skills lead to errors and unintended results. :laughing: Any input would be greatly appreciated! Thx

If the above code works for you and you just wanted only the City, then you would only need to set ‘parts’ to only grab City and nothing else. let parts = [city]; Just note that this does heavily rely on consistent address formatting and a certain format at that. It’s not a perfect solution. In …

Hi, @Jeff_Hager . Yes, I plan on using Radar to auto-populate the address input on the form I’m building and from my testing the formatting seems consistent: [Address 01] [Address 02], [City], [State] [Zip] [Country] The edit you gave me works perfectly (of course!) but I’m also considering just us…

Why don’t you use a comma as your delimiter?

If you’re using the Radar API, you should be able to extract the City directly with a Query JSON column.

Hey @ThinhDinh . Yeah, that is much cleaner and eliminates an extra column. The goal here is to create some in-app filter parameters. My thought is in case the client wants to filter by state, zip, or country in the future, I can just add additional SV columns to accommodate. Am I overthinking?

Hi @Darren_Murphy . Appreciate the input. I’ve only tested the Radar output using an installation in someone else’s app; I haven’t set up the API yet so don’t know exactly what my options are yet. Does the query workflow you describe consume updates or is like having Radar convert addresses to long a…

Extracting specific parts of an address

Ask for Help

Darren_Murphy July 17, 2024, 10:55am 14

Here is that tutorial:

Topic		Replies	Views
Extract Country and City Ask for Help	3	77	March 18, 2025
Extract Part of an Address Ask for Help	6	48	February 18, 2025
Extracting Matching Text Ask for Help	1	520	December 1, 2022
How to get state from address Ask for Help	3	93	April 15, 2025
:earth_americas: JSON Address Picker (Google Maps) Project Showcase	4	950	December 27, 2022

Extracting specific parts of an address

Related topics