String Operations

Performs a variety of text manipulation operations on an input string and returns the result.

Purpose

Use String Operations whenever a workflow needs to transform, inspect, or extract part of a text value. Common use cases include normalising casing before a comparison, extracting a file extension from a path, replacing placeholder tokens in a template, splitting a delimited string into an array, or trimming whitespace from user-supplied data.

Inputs

Field	Type	Required	Description
Input String	Text	Yes	The text value to operate on.
Operation	Dropdown	Yes	The operation to perform. See the Operations table below.
StartIndex	Text	No	Zero-based character position at which to begin extraction. Visible when Operation is Substring.
Length	Text	No	Number of characters to extract. Visible when Operation is Substring.
Value	Text	No	The substring to search for, test, or locate. Visible when Operation is Contains, StartsWith, EndsWith, IndexOf, or LastIndexOf.
OldValue	Text	No	The substring to find and replace. Visible when Operation is Replace.
NewValue	Text	No	The replacement text. Visible when Operation is Replace.
Separator	Text	No	Delimiter used to split the string or to join path segments. Visible when Operation is Split or GetPathToDepth.
Depth	Text	No	Number of path segments to keep from the start of the string. Visible when Operation is GetPathToDepth.
Pattern	Text	No	Regular expression pattern to match. Visible when Operation is RegexReplace.
Replacement	Text	No	Text to substitute for each regex match. Visible when Operation is RegexReplace.

Visibility Rules

StartIndex and Length are visible when Operation is Substring. Value is visible when Operation is Contains, StartsWith, EndsWith, IndexOf, or LastIndexOf. OldValue and NewValue are visible when Operation is Replace. Separator is visible when Operation is Split or GetPathToDepth. Depth is visible when Operation is GetPathToDepth. Pattern and Replacement are visible when Operation is RegexReplace.

Operations

Operation	Description
Substring	Extracts a portion of the string starting at StartIndex, optionally limited to Length characters.
Contains	Returns true if the string contains the specified Value.
StartsWith	Returns true if the string begins with the specified Value.
EndsWith	Returns true if the string ends with the specified Value.
IndexOf	Returns the zero-based index of the first occurrence of Value, or -1 if not found.
LastIndexOf	Returns the zero-based index of the last occurrence of Value, or -1 if not found.
ToUpper	Converts all characters to uppercase.
ToLower	Converts all characters to lowercase.
Trim	Removes leading and trailing whitespace.
TrimStart	Removes leading whitespace only.
TrimEnd	Removes trailing whitespace only.
Replace	Replaces every occurrence of OldValue with NewValue.
Split	Splits the string at each occurrence of Separator and returns an array of substrings.
Length	Returns the number of characters in the string.
RegexReplace	Replaces every substring matching Pattern with Replacement.
GetPathToDepth	Splits the string by Separator and returns only the first Depth segments rejoined.

Outputs

Name	Description
Result	The outcome of the operation. The type varies by operation: a string for most transformations, a boolean for Contains / StartsWith / EndsWith, an integer for IndexOf / LastIndexOf / Length, and a list of strings for Split.

Examples

Extract a file extension

Field	Value
Input String	report_final.pdf
Operation	LastIndexOf then Substring

Alternatively use GetPathToDepth with a dot separator to isolate path components.

Split a comma-separated list

Field	Value
Input String	alice,bob,carol
Operation	Split
Separator	,
Result	["alice", "bob", "carol"]