Which action is used to remove whitespace characters from text values?

The action used to remove whitespace characters from text values is Trim. The Trim function specifically targets spaces before and after a text string, which is particularly useful for cleaning up inputs that might have unintended leading or trailing spaces. This action ensures that the text is processed in a consistent manner, allowing for accurate comparisons and data processing.

In scenarios where data inputs might come from user entries or external data sources, it is common to encounter extra spaces that can lead to errors in logic or mismatches in string comparisons. By applying the Trim function, you can effectively eliminate these unwanted whitespace characters, enabling cleaner and more reliable data manipulation.

Other options like Pad, Substring, and Split serve different functions. Pad is typically used to add spaces or characters to the beginning or end of a string to reach a certain length. Substring allows for extracting a part of a string based on specified indices, which doesn’t address whitespace removal. Split is used to divide a string into an array based on a specified delimiter, which also does not directly remove whitespace but rather separates text into chunks.