You have a population of workers who have put multiple names in their Legal Name - First Name Workday delivered field. Your third-party vendor only accepts one-word first names. For workers that have included a middle name, the first and middle names are separated by a single space.
You have been asked to implement the following logic:
* Extract the value before the single space from the Legal Name - First Name Workday delivered field.
* Count the number of characters in the extracted value.
* Identify if the number of characters is greater than.
* If the count of characters is greater than 0, use the extracted value. Otherwise, use the Legal Name - First Name Workday delivered field.
What functions are needed to achieve the end goal?
A. Extract Single Instance, Text Length, Numeric Constant, True/False Condition
B. Text Constant, Substring Text, Arithmetic Calculation, Evaluate Expression
C. Format Text, Convert Text to Number, True/False Condition, Evaluate Expression
D. Substring Text, Text Length, True/False Condition, Evaluate Expression
