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.
Hi @Noah_Beach ,
I would create it with VC and index expression.
Something like this.
Index(Split([Address], ","), 1)
Index(Split([Address], ","), 2)
I see. Thank you for your help.
User | Count |
---|---|
43 | |
29 | |
25 | |
23 | |
13 |