You have a population of workers who have put multiple names in their Legal Name...

The task involves processing the "Legal Name - First Name" field in Workday to meet a third-party vendor’s requirement of accepting only one-word first names. For workers with multiple names (e.g., "John Paul"), separated by a single space, the logic must:

Extract the value before the space (e.g., "John" from "John Paul").

Count the characters in the extracted value.

Check if the character count is greater than 0.

Use the extracted value if the count is greater than 0; otherwise, use the original "Legal Name - First Name" field.

This logic is typically implemented in Workday using calculated fields within a custom report or integration (e.g., EIB or Studio). Let’s break down the required functions:

Substring Text:This function is needed to extract the portion of the "Legal Name - First Name" field before the space. In Workday, the Substring Text function allows you to specify a starting position (e.g., 1) and extract text up to a delimiter (e.g., a space). For example, Substring Text("John Paul", 1, Index of " ") would return "John."

Text Length:After extracting the substring (e.g., "John"), the logic requires counting its characters to ensure it’s valid. The Text Length function returns the number of characters in a text string (e.g., Text Length("John") = 4). This is critical for the condition check.

True/False Condition:The logic involves a conditional check: "Is the number of characters greater than 0?" The True/False Condition function evaluates this (e.g., Text Length(extracted value) > 0), returning True if the extracted value exists and False if it’s empty (e.g., if no space exists or extraction fails).

Evaluate Expression:This function implements the if-then-else logic: if the character count is greater than 0, use the extracted value (e.g., "John"); otherwise, use the original "Legal Name - First Name" field (e.g., "John Paul"). Evaluate Expression combines the True/False Condition with the output values.

Option Analysis:

A. Extract Single Instance, Text Length, Numeric Constant, True/False Condition: Incorrect. Extract Single Instance is used for multi-instance fields (e.g., selecting one dependent), not text parsing. Numeric Constant isn’t needed here, as no fixed number is involved.

B. Text Constant, Substring Text, Arithmetic Calculation, Evaluate Expression: Incorrect. Text Constant provides a fixed string (e.g., "abc"), not dynamic extraction. Arithmetic Calculation isn’t required, as this is a text length check, not a numeric operation beyond comparison.

C. Format Text, Convert Text to Number, True/False Condition, Evaluate Expression: Incorrect. Format Text adjusts text appearance (e.g., capitalization), not extraction. Convert Text to Number isn’t needed, as Text Length already returns a number.

D. Substring Text, Text Length, True/False Condition, Evaluate Expression: Correct. These functions align perfectly with the requirements: extract the first name, count its length, check the condition, and choose the output.

Implementation:

Create a calculated field using Substring Text to extract text before the space.

Use Text Length to count characters in the extracted value.

Use True/False Condition to check if the length > 0.

Use Evaluate Expression to return the extracted value or the original field based on the condition.

References from Workday Pro Integrations Study Guide:

Workday Calculated Fields: Section on "Text Functions" details Substring Text and Text Length usage.

Integration System Fundamentals: Explains how calculated fields with conditions (True/False, Evaluate Expression) transform data for third-party systems.

Core Connectors & Document Transformation: Highlights text manipulation for outbound integration requirements.