AnsweredAssumed Answered

Store Address in separate Fields

Question asked by brightlight on Dec 18, 2017
Latest reply on Dec 19, 2017 by brightlight

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.