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 address string field into its components such as street number, street name, street address, unit, city, state, postal code, and country, adding these as new output fields with a configurable prefix.

Inputs

  • Address Field (required) — The field containing the address string to parse.
  • Output Prefix — Prefix to prepend to each output field name, for example 'address_' to produce fields like address_city, address_state, etc.
  • Options — Optional parameters to control behavior: case insensitivity when matching field names (default true), continue processing on failure (default true), debug mode (include detailed debug info, default false), skip items if no changes made (default false), and track changes (include a _changes field showing before/after values, default false).

Output shape

a list of items each containing the original data plus parsed address parts as new fields with the configured prefix

Each output item mirrors the input item with added address component fields. If track changes is enabled, a _changes array details modification info. If debug mode is enabled, a _debug object provides detailed field lookup and parsing info. If continue on fail is false, node will error on failure to parse an item. If skip unchanged is true, items with no changes will be omitted from output.

Examples

Example 1: Given an input item with a field 'address' containing a full address string, the node outputs that item with additional fields prefixed by 'address_' such as address_streetNumber, address_streetName, address_city, address_state, address_postalCode, and address_country extracted.

Address Field = 'address', Output Prefix = 'address_', Options as default.

Discussion