String & DateTime Activities
String and DateTime activities cover the most common text manipulation and date/time operations needed during automation: searching, splitting, joining, formatting, regex matching/replacement, and date arithmetic across timezones.
DateTime (4)
Add To DateTimeAdd To DateTime
Adds days, hours, minutes, or seconds to a DateTime value and stores the result.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Input | DateTime | Yes | — | The DateTime variable or value to modify |
Amount | String | Yes | 1 | Amount to add (can be negative to subtract) |
Unit | String | No | Days | Time unit: Days, Hours, Minutes, Seconds, Months, Years |
Result | DateTime | Yes | — | Variable to store the resulting DateTime |
Format DateTimeFormat DateTime
Formats a DateTime value to a string using a custom format pattern (e.g., yyyy-MM-dd, dd/MM/yyyy HH:mm).
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Input | DateTime | Yes | — | The DateTime variable or value to format |
Format | String | Yes | yyyy-MM-dd HH:mm:ss | Format pattern (e.g. yyyy-MM-dd, dd/MM/yyyy HH:mm:ss, MMMM d yyyy) |
Result | String | Yes | — | Variable to store the formatted string result |
Get Current DateTimeGet Current DateTime
Gets the current date and time (local or UTC) and stores it in a DateTime variable.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Kind | String | No | Now | Now (local time) or UtcNow (UTC time) |
Result | DateTime | Yes | — | Variable to store the DateTime result |
Parse DateTimeParse DateTime
Parses a date/time string into a DateTime value, optionally using an exact format pattern.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Input | String | Yes | — | The date/time string to parse (e.g. '2026-03-15', 'March 23, 2026 10:30 AM') |
Format | String | No | — | Optional exact format pattern (e.g. yyyy-MM-dd). Leave empty for auto-detection. |
Result | DateTime | Yes | — | Variable to store the parsed DateTime result |
String (9)
Regex Is MatchRegex Is Match
Tests whether a string matches a regular expression pattern and returns true/false.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Input | String | Yes | — | The string to test against the pattern |
Pattern | String | Yes | — | The regular expression pattern to test, e.g. ^\d{3}-\d{4}$ |
IgnoreCase | Boolean | No | false | If true, performs case-insensitive matching |
Result | Boolean | Yes | — | Variable to store the Boolean result (true if pattern matches) |
Regex MatchRegex Match
Extracts the first match (or all matches) of a regular expression pattern from a string.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Input | String | Yes | — | The string to search within |
Pattern | String | Yes | — | The regular expression pattern, e.g. \d{3}-\d{4} |
MatchAll | Boolean | No | false | If true, returns all matches as an array; otherwise returns the first match only |
IgnoreCase | Boolean | No | false | If true, performs case-insensitive matching |
Result | String | Yes | — | Variable to store the match result (string or string[]) |
Regex ReplaceRegex Replace
Replaces all occurrences in a string that match a regular expression pattern with a replacement string.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Input | String | Yes | — | The string to perform regex replacements on |
Pattern | String | Yes | — | The regular expression pattern to match |
Replacement | String | No | — | The replacement string. Use $1, $2, etc. for captured groups. |
IgnoreCase | Boolean | No | false | If true, performs case-insensitive matching |
Result | String | Yes | — | Variable to store the resulting string |
String ContainsString Contains
Checks whether a string contains a specified substring and stores the Boolean result in a variable.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Input | String | Yes | — | The string to search within |
Substring | String | Yes | — | The substring to search for |
IgnoreCase | Boolean | No | false | If true, performs a case-insensitive comparison |
Result | Boolean | Yes | — | Variable to store the Boolean result |
String FormatString Format
Formats a string by replacing numbered placeholders {0}, {1}, {2}... with the provided argument values.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
FormatString | String | Yes | — | The format string with placeholders, e.g. 'Hello {0}, you have {1} items' |
Arguments | String | No | — | Comma-separated values for placeholders. Use quotes for values containing commas. |
Result | String | Yes | — | Variable to store the formatted string result |
String JoinString Join
Joins an array or collection of strings using the specified separator and stores the resulting string.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Input | String | Yes | — | The array or collection of strings to join |
Separator | String | No | , | The separator to place between items (default: ', '). Use \n for newline. |
Result | String | Yes | — | Variable to store the joined string |
String ReplaceString Replace
Replaces all occurrences of a search string within the input with a replacement string.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Input | String | Yes | — | The string to perform replacements on |
Search | String | Yes | — | The string to search for |
Replacement | String | No | — | The replacement string (empty to remove occurrences) |
IgnoreCase | Boolean | No | false | If true, performs case-insensitive replacement |
Result | String | Yes | — | Variable to store the resulting string |
String SplitString Split
Splits a string by the specified delimiter and stores the resulting string array in a variable.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Input | String | Yes | — | The string to split |
Delimiter | String | No | , | The delimiter to split by (default: comma). Use \n for newline, \t for tab. |
TrimEntries | Boolean | No | true | Trim whitespace from each resulting part |
RemoveEmpty | Boolean | No | true | Remove empty entries from the result |
Result | String | Yes | — | Variable to store the resulting string array |
String TrimString Trim
Trims whitespace or specified characters from the start, end, or both sides of a string.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Input | String | Yes | — | The string to trim |
TrimChars | String | No | — | Characters to trim. Leave empty to trim whitespace. |
TrimMode | String | No | Both | Where to trim: Both, Start, or End Allowed: Both, Start, End |
Result | String | Yes | — | Variable to store the trimmed string |