String Operations
These String Operations blocks return information about strings or perform manipulations on strings.
Block | Icon | Description |
---|---|---|
Concatenate | ![]() | Joins multiple text strings into one string |
Left | ![]() | Returns the specified number of leftmost characters from a string |
Length | ![]() | Returns the number of characters in a string |
Right | ![]() | Returns the specified number of rightmost characters from a string |
Substring | ![]() | Returns a specific substring from a string |
Replace | ![]() | Replaces a substring of a text value |
Trim | ![]() | Removes all leading and trailing whitespace from text |
Split | no icon | Separates an input string into pieces, as defined by a delimiter, and returns the pieces as rows in an output table |