cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Store Address in separate Fields

Jump to solution

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.

Labels: (1)
Tags (2)
0 Kudos
Reply
2 Replies
Workflow Hero

Re: Store Address in separate Fields

Jump to solution

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.

Reply
Workflow Hero

Re: Store Address in separate Fields

Jump to solution

Thank you,

I will definitely try this mark as answer if succeeded. 

Reply