If you have address data with delimiters (e.g. commas), you can easily parse into separate columns using a Split Col transform.
If it isn’t delimited, then it is trickier. But you can do it using Replace a regular expression.
Followed by Split Col.
parse-address.transform (2.5 KB)
https://regex101.com/ is useful for helping with setting up regular expressions.
This regular expression could get quite large and complex for real world data!