FlowEngine Data Standardize & CleanInstall

Summary

Parse and decompose phone numbers from a specified field into multiple standardized formats and components, adding these as new output fields with a configurable prefix.

Inputs

• Phone Field (required) — Specify the name of the field containing the phone number to parse. Supports case-insensitive matching.
• Default Country Code — Specify the default country code to assume for phone numbers where the country code is not detected (e.g., '1' for US/Canada). Defaults to '1'.
• Output Prefix — Define a string prefix for the output fields added with parsed phone number components (e.g., 'phone_' to create fields like phone_e164, phone_national). Defaults to 'phone_'.
• Options — Configure processing options such as tracking changes (adds before/after details), whether to continue on failure, skip items with no changes, enable case-insensitive field matching, and include debug info detailing field lookup and transformations.

Output shape

a list of items reflecting the input items each with parsed phone number fields added

For each input item, outputs include new fields describing the parsed phone number components under keys prefixed by the specified Output Prefix. The parsed fields include e164, national, international formats, country code, area code, local number, extension, and a validity flag. If tracking changes is enabled, a _changes array shows what was modified. If debug mode is enabled, detailed debug information is included in a _debug field. Items with no changes can be skipped from output if 'Skip Unchanged' is enabled.