FlowEngine Data Standardize & Clean icon

FlowEngine Data Standardize & Clean

Clean and transform data without code - deduplicate, format phones, normalize emails, and more

Parse Address

AI-generated

Summary

Parse a single string address field into its component parts such as street number, street name, street address, unit, city, state, postal code, and country, adding these as new fields with a configurable prefix to each resulting item in the workflow.

Inputs

  • Address Field (required) — The name of the field containing the string address to parse.
  • Output Prefix — Prefix to prepend to each parsed address field name in the output (e.g., 'address_').
  • Options — Collection of options including 'Track Changes' to add a _changes field showing modifications, 'Continue On Fail' to continue processing other items after failure, 'Skip Unchanged' to omit items with no changes from output, 'Case Insensitive Fields' to look up field names case-insensitively, and 'Debug Mode' to include detailed debug info under _debug field.

Output shape

a list of items, each with the original data plus new fields for parsed address components prefixed by the configured output prefix

If 'Track Changes' option is enabled, each output item will include a _changes array detailing which address components were added. If 'Skip Unchanged' is set, items without any parsed address fields added are excluded from the result. 'Debug Mode' adds a _debug object showing details of the field lookup and parsing steps.

Examples

Example 1: Given items with an 'address' field containing full address strings, parse and extract components into separate fields prefixed with 'address_'.

Set 'Address Field' to 'address', 'Output Prefix' to 'address_', and optionally enable options like Track Changes or Debug Mode.

Discussion