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.