FlowEngine Data Standardize & CleanInstall

Summary

Parse a username string from a specified field to extract its component parts such as first name, last name, middle name, initials, and full name, optionally prefixing these output fields.

Inputs

• Username Field (required) — The field containing the username string to parse (e.g., "john_doe", "JohnDoe").
• Output Prefix — A string prefix applied to each output field name. Leave empty to have no prefix.
• Options - Track Changes — Include a _changes field in the output showing what was modified with before/after values.
• Options - Continue On Fail — Whether to continue processing subsequent items if one item fails.
• Options - Skip Unchanged — Exclude items from output if no changes were made during parsing.
• Options - Case Insensitive Fields — Match the username field name case-insensitively (e.g., matches "username", "Username", "USERNAME").
• Options - Debug Mode — Include detailed debug information in a _debug field about the field lookup and transformation steps.

Output shape

A list of items where each item's JSON includes the parsed username components as separate fields: firstName, lastName, middleName, initials, and fullName, with optional prefixing. It may also include metadata fields such as _changes, _changesSummary, and _debug depending on options.

Each output item corresponds to an input item. If Track Changes is enabled, modifications are detailed in the _changes field. If Skip Unchanged is enabled, items without changes are omitted. Debug mode adds detailed tracing information to _debug. Field name matching respects the Case Insensitive Fields option.

Examples

Example 1: Parsing a typical underscore-separated username

Username Field: "username", Output Prefix: "user_"; Options: all defaults (Track Changes disabled). Input "username" value "john_doe" produces output fields user_firstName="john", user_lastName="doe", etc.