Extracting List values from SPLIT and placing in a field

[Noah_Beach]

I need to break down an address and place the values into address, address 2, city, state, zip code. This is all on 1 form by the way. I was thinking of using split() based off commas, but I do not know how to extract the returned list values and place them into each field. If you can help please do. Thanks.

[takuya_miyai]

Hi @Noah_Beach ,

I would create it with VC and index expression.

Something like this.

Street VC formula

Index(Split([Address], ","), 1)

City VC formula

Index(Split([Address], ","), 2)

[Noah_Beach]

I see. Thank you for your help.