Parsing address data into multiple columns

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) is useful for helping with setting up regular expressions.

This regular expression could get quite large and complex for real world data!