Text Functions¶
Text functions transform strings for display and logic.
Goal¶
Format or inspect text values in an expression.
Common functions¶
| Function | Purpose |
|---|---|
Text.UpperCase() |
Uppercase |
Text.LowerCase() |
Lowercase |
Text.Trim() |
Remove edge whitespace |
Text.Length() |
Character count |
Text.Contains() |
Substring test |
Text.Substring() |
Extract part of a string |
Text.Replace() |
Replace text |
Text.Concat() |
Join strings |
Steps¶
- Open the Expression Builder from a Text Field.
- Choose the Text category.
- Insert the function and replace placeholders with fields or literals.
- Apply and Preview.
[ Screenshot: Text functions in Expression Builder ]
Example¶
Display a customer name in uppercase: