Splitting an address into parts

Questions and Help
1

Is there a way to split an address up into parts? for instance for this address,

1872 north patchwork avenue Tooele Utah 84074

Could we split it up into
1872 north patchwork avenue
tooele
utah
84074

Thank you!

2

Hi,

Text Blaze has a formula command that can split things using the "split" function. You can learn more here:

In your example though, I don't see clear splitting boundaries that can be programmatically identified, so I am not sure you could write a reliable formula for it.

You could try using AI Blaze and use an AI prompt to format it:

3

Yeah I've been playing around with the split function to see if I could get it to work across multiple different address styles and haven't been able to get it to work.

4

This example may be useful:

5

Thank you this was very helpful. And I was able to figure out the city issue so it only pulled the city name. thank you!