Store Address in separate Fields

+9

I wanted to know how to store address in separate field. For example, i have an address 100 Sue Street, Dreamville, Hawaii 96804, USA.

I want to store address: 100 Sue Street in address field

I want to store City: Dreamville in city field

I want to store State: Hawaii in state field

I want to store Zip: 96804 in zip field

I want to store Country: USA in country field

I am using a reg exp: /s(.*) to split the address variable, store it in the collection variable, and rest is unknown.

Userlevel 5

+14

so you have to setup a for each loop to iterate over collection.

then within the loop you have to determine somehow, what piece of address you are currently working with, and store it to some temporary variable.

if the address format is always the same you could use loop index.

so eg. if idx=1, store current collection element to eg. varStreet (use collection operation for that)

so eg. if idx=2, store current collection element to eg. varCity

etc.

once you have processed all the address parts this way, you can create or update an item with use of variables.

+9

Thank you, ‌

I will definitely try this mark as answer if succeeded.

Sign up