FlowEngine Data Standardize & CleanInstall

Summary

Parse username strings from a specified input field to extract components such as first name, last name, middle name, initials, and the full normalized username.

Inputs

• Username Field (required) — The field in incoming data that contains the username string to parse (e.g., "john_doe", "JohnDoe").
• Output Prefix — Optional prefix added to each output field name generated from the parsed username parts. If empty, no prefix is applied.
• Options — Additional flags including case insensitive field matching, continue processing on failure, debug mode for detailed info, skipping unchanged items, and tracking changes with before/after values.

Output shape

a list of items where each item's JSON contains the original data plus new fields for parsed username parts: firstName, lastName, middleName, initials, and fullName, each optionally prefixed as configured.

If the specified username field is missing or not a string, the item will be included with no changes unless tracking changes is disabled. Debug information and change tracking details are optionally included in _debug and _changes fields respectively. Output may exclude unchanged items if 'Skip Unchanged' is enabled.

Examples

Example 1: Parsing usernames such as "john_doe" or "JohnDoe" to extract their components

Set 'Username Field' to the data's username field name, optionally set an 'Output Prefix' to distinguish parsed fields, and configure options for change tracking or debugging as needed.