This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.
I’ve tried and Tried and found the AI useless in formatting the Address in the Right way.
I have this expression coming in from Jotform
We mostly get Unit addresses, but some times it is a standalone house.
So I need to extract both using
Example With A Unit Address:
Street name: xxxxxx Unit/Street Number: Unit x/xx City: xxxxxx State: xxx Postal code: xxxx Country: xxxxxxxx
Example Without A Unit Address:
Street name: xxxxxxxxtUnit/Street Number: xx City: xxxxxxx State: xxx Postal code: xxxx Country: xxxxxxxx
I want to import it into Halo which has 4x Address fields & a Postcode field.
I want to output like this
Address 1: Unit xxxxx xxxxxx xxxxx (if it is a Unit)
Address 1: xx xxxxxx xxxxx (if Not a unit)
Address 2: xxxxxx
Address 3: xxx
Address 4: xxxxxxx
Address 5: xxxx
