We can definitely do this in Parabola. The main parts to consider are the spaces and commas after the city names. Here’s how you can set this up:
Start by importing your source data. Use a “Split column” step to target your
Owner City State Zip column. You can split on a comma-space
, . Your cities should now be separated.
Your state and zip data should be in a column called
Owner City State Zip (1). Use another “Split column” step to target that column and split on every space. Your states and zips should now be separated too.
To remove the last 4 digits in your zip code, add a “Use regex” step to target your
Owner City State Zip (2) column. Use the expression
-\d* to find the last 4 digits and replace them with a blank value.
Lastly, the “Rename columns” and the “Select columns” steps are used to clean up the data.
Copy and paste this snippet anywhere into your flow to duplicate the step settings used above: