How to split the Address into Street, City, State and Zip?

0
Hi, In my application, I am getting address from Google Maps. Now I want to split that address into Street, City, State and Zip code. For e.g., 5501 McNeil Dr, Austin, TX 78729, USA this is the address I am getting from Google Maps. Now I want to split it as Street: 5501 McNeil Dr, City: Austin, State: TX and Zip: 78729. How can I approch this criteria? Please help me. Is it possible with existing functionality or Do I need to write custom java action for this? I hope I am clear.   Thanks, Venkat.
asked
3 answers
0

Do you have the following settings?

answered
0

Hi Venkat,

First split at comma and then split the state / zip at the space?

Would that do the trick?

 

Success,

Egbert

answered
0

Hi Venkat, 

 

How do you import the result from Google Maps? Do you get the first result in a string value or are you receiving the JSON result?

I would suggest to use the JSON output from Google because then you can use the object types that Google provides. https://developers.google.com/maps/documentation/geocoding/intro. 

 

But off course you can also use default Mendix string operations: https://docs.mendix.com/refguide7/string-function-calls.

answered