String Expressions

 

Note - In general, all inputs marked as String can accept any Data Type and will be cast to a String before execution.

Concat

Description:

The Concat operation creates a Result by concatenating Input 1 and Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

Concat

Contains

Description:

The Contains operation creates a Result by determining if Input 1 contains Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Boolean

Contains

StartsWith

Description:

The StartsWith operation creates a Result by determining if Input 1 starts with Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Boolean

StartsWith

EndsWith

Description:

The EndsWith operation creates a Result by determining if Input 1 ends with Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Boolean

EndsWith

IndexOf

Description:

The IndexOf operation creates a Result by determining the index (0-based) of the first occurrence of Input 2 within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

IndexOf

LastIndexOf

Description:

The LastIndexOf operation creates a Result by determining the index (0-based) of the last occurrence of Input 2 within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

LastIndexOf

Replace

Description:

The Replace operation creates a Result by replacing all occurrences of Input 2 within Input 1 with Input 3.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 3
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

Replace

Substring

Description:

The Substring operation creates a Result by extracting a substring of Input 1 starting from the index (0-based) of Input 2 and ending at the index (0-based) of Input 3.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int16
  • Int32
  • Int64
  • Double

Input 3
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int16
  • Int32
  • Int64
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

Substring

ToLower

Description:

The ToLower operation creates a Result by lowercasing all characters within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

ToLower

ToUpper

Description:

The ToUpper operation creates a Result by uppercasing all characters within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

ToUpper

TrimStart

Description:

The TrimStart operation creates a Result by removing Input 2 from the beginning of Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

TrimStart

TrimEnd

Description:

The TrimEnd operation creates a Result by removing Input 2 from the end of Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

TrimEnd

Trim

Description:

The Trim operation creates a Result by removing all spaces from the beginning and end of Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

Trim

Length

Description:

The Length operation creates a Result by calculating the number of characters in Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

Length

ReplaceCharHtmlCode

Description:

The ReplaceCharHtmlCode operation creates a Result by replacing characters in Input 1 with their HTML character codes.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

ReplaceHtmlCodeChar

Description:

The ReplaceHtmlCodeChar operation creates a Result by replacing HTML character codes in Input 1 with their normal characters.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

SubstringToEnd

Description:

The SubstringToEnd operation creates a Result by extracting a substring of Input 1 starting from the index (1-based) of Input 2 to the end.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int16
  • Int32
  • Int64
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

SubstringToEnd

SplitAndSelect

Description:

The SplitAndSelect operation creates a Result by splitting Input 1 on the value given by Input 2 and selecting the substring given by Input 3 (using 0-based index).

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 3
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int16
  • Int32
  • Int64
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

SplitAndSelect

RemoveLeading

Description:

The RemoveLeading operation creates a Result by potentially removing up to 2 leading characters from the beginning of Input 1, if applicable.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

RemoveLeading

ValidateEmail

Description:

The ValidateEmail operation creates a Result by determining if Input 1 is in a proper email format (x@y.z).

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Boolean

ValidateEmail

FormatPhone

Description:

The FormatPhone operation creates a Result by formatting Input 1 into a 11 or 10 digit x-xxx-xxx-xxxx format.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

FormatPhone

RemoveTrailing

Description:

The RemoveTrailing operation creates a Result by potentially removing a trailing character from the end of Input 1, if applicable.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

RemoveTrailing

EmptyString

Description:

The EmptyString operation creates a Result by determining if Input 1 is null.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Boolean

EmptyString

FirstNCharacters

Description:

The FirstNCharacters operation creates a Result by selecting the first N characters, specified by Input 2, from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int16
  • Int32
  • Int64
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

FirstNCharacters

ReturnsLineFeeds

Description:

The ReturnsLineFeeds operation creates a Result by removing any spacing caused by additional lines (/r and /n) within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

PadRight

Description:

The PadRight operation creates a Result by adding a space to the end of Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

PadRight

ProperCase

Description:

The ProperCase operation creates a Result by uppercasing the first letter of each word contained within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

ProperCase

ReplaceFullValue

Description:

The ReplaceFullValue operation creates a Result by first determining if Input 1 is equal to Input 2, and if so, replaces the full value of Input 1 with Input 3.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 3
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

ReplaceFullValue

DefaultBlanks

Description:

The DefaultBlanks operation creates a Result by replacing all blank values within Input 1 with Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

DefaultBlanks

RemoveNonAlphaNumeric

Description:

The RemoveNonAlphaNumeric operation creates a Result by removing all non-alphabetic and non-numeric characters from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

RemoveNonAlphaNumeric

RemoveNonAlphabetic

Description:

The RemoveNonAlphabetic operation creates a Result by removing all non-alphabetic characters from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

RemoveNonAlphabetic

RemoveAlphabetic

Description:

The RemoveAlphabetic operation creates a Result by removing all alphabetic characters from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

RemoveAlphabetic

RemoveNumeric

Description:

The RemoveNumeric operation creates a Result by removing all numeric characters from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

RemoveNumeric

RemoveNonNumeric

Description:

The RemoveNonNumeric operation creates a Result by removing all non-numeric characters from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

RemoveNonNumeric

RemoveSymbols

Description:

The RemoveSymbols operation creates a Result by removing all symbol characters from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

RemoveSymbols

RemoveSpace

Description:

The RemoveSpace operation creates a Result by removing all spaces from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

RemoveSpace

ExtractPhoneNumber

Description:

The ExtractPhoneNumber operation creates a Result by extracting a telephone number from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

ExtractPhoneNumber

ExtractEmail

Description:

The ExtractEmail operation creates a Result by extracting an email address from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

ConcatWithSpaceSeparator

Description:

The ConcatWithSpaceSeparator operation creates a Result by concatenating Input 1 and Input 2 while including a space in-between.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

ConcatWithSpaceSeparator

ReplaceHTMLTags

Description:

The ReplaceHTMLTags operation creates a Result by removing all HTML tags within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

ReplaceHTMLTags

AddLeadingZeroes

Description:

The AddLeadingZeroes operation creates a Result by evaluating Input 1 and Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int16
  • Int32
  • Int64
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

Hyphenate

Description:

The Hyphenate operation creates a Result by replacing all spaces within Input 1 with a hyphen.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

Hyphenate

ContainsHTMLTags

Description:

The ContainsHTMLTags operation creates a Result by determining if Input 1 contains any HTML tags.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

ContainsHTMLTags

Normalize

Description:

The Normalize operation creates a Result by evaluating Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

GetFirstWord

Description:

The GetFirstWord operation creates a Result by extracting the first word from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

GetFirstWord

GetFirstNWords

Description:

The GetFirstNWords operation creates a Result by extracting the first N words, specified by Input 2, from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int16
  • Int32
  • Int64
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

GetFirstNWords

GetFirstWordAfterIndex

Description:

The GetFirstWordAfterIndex operation creates a Result by extracting the first word from Input 1 after the index specified by Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int16
  • Int32
  • Int64
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

GetFirstWordAfterIndex

RemoveFirstNWords

Description:

The RemoveFirstNWords operation creates a Result by removing the first N words, specified by Input 2, from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int16
  • Int32
  • Int64
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

GetLastWord

Description:

The GetLastWord operation creates a Result by extracting the last word from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

GetLastWord

GetLastNWords

Description:

The GetLastNWords operation creates a Result by extracting the last N words, specified by Input 2, from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int16
  • Int32
  • Int64
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

RemoveLastNWords

Description:

The RemoveLastNWords operation creates a Result by removing the last N words, specified by Input 2, from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int16
  • Int32
  • Int64
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

RemoveLastWord

Description:

The RemoveLastWord operation creates a Result by removing the last word from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

RemoveLastWord

GetFirstWordContaining

Description:

The GetFirstWordContaining operation creates a Result by extracting the first word from Input 1 that contains Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

GetFirstWordContaining

GetFirstNWordsContaining

Description:

The GetFirstNWordsContaining operation creates a Result by extracting the first N words, as specified by Input 3, from Input 1 that contain Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 3
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int16
  • Int32
  • Int64
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

GetLastWordContaining

Description:

The GetLastWordContaining operation creates a Result by extracting the last word from Input 1 that contains Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

GetLastWordContaining

RemoveLastWordContaining

Description:

The RemoveLastWordContaining operation creates a Result by removing the last word from Input 1 that contains Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

RemoveFirstWordContaining

Description:

The RemoveFirstWordContaining operation creates a Result by removing the first word from Input 1 that contains Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

RemoveFirstWordContaining

GetFirstWordBefore

Description:

The GetFirstWordBefore operation creates a Result by extracting the first word before Input 2 within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

GetFirstWordBefore

GetFirstWordAfter

Description:

The GetFirstWordAfter operation creates a Result by extracting the first word after Input 2 within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

GetNWordsAfter

Description:

The GetNWordsAfter operation creates a Result by extracting the N words, specified by Input 3, after Input 2 within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 3
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int16
  • Int32
  • Int64
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

ContainsAlphabetic

Description:

The ContainsAlphabetic operation creates a Result by determining if Input 1 contains any alphabetic characters.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Boolean

ContainsAlphabetic

ContainsNonAlphaNumeric

Description:

The ContainsNonAlphaNumeric operation creates a Result by determining if Input 1 contains any non-alphabetic characters.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Boolean

ContainsNonAlphaNumeric

ContainsNumeric

Description:

The ContainsNumeric operation creates a Result by determining if Input 1 contains any numeric characters.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Boolean

ContainsNumeric

ContainsNonNumeric

Description:

The ContainsNonNumeric operation creates a Result by determining if Input 1 contains any non-numeric characters.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Boolean

ContainsNonNumeric

DeduplicateWords

Description:

The DeduplicateWords operation creates a Result by removing any duplicate words within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

DeduplicateWords

OccursRightAfter

Description:

The OccursRightAfter operation creates a Result by determining if Input 3 occurs directly after Input 2 within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 3
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Boolean

OccursRightBefore

Description:

The OccursRightBefore operation creates a Result by determining if Input 3 occurs directly before Input 2 within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 3
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Boolean

OccursBefore

Description:

The OccursBefore operation creates a Result by determining if Input 3 occurs at some point before Input 2 within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 3
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Boolean

OccursBefore

OccursAfter

Description:

The OccursAfter operation creates a Result by determining if Input 3 occurs at some point after Input 2 within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 3
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Boolean

OccursAfter

OccursAfterIndex

Description:

The OccursAfterIndex operation creates a Result by determining if Input 2 occurs within Input 1 after the index (0-based) specified by Input 3.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 3
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int16
  • Int32
  • Int64
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Boolean

OccursBeforeIndex

Description:

The OccursBeforeIndex operation creates a Result by determining if Input 2 occurs within Input 1 before the index (0-based) specified by Input 3.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 3
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int16
  • Int32
  • Int64
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Boolean

CountOccurencesBefore

Description:

The CountOccurencesBefore operation creates a Result by calculating the number of occurences of Input 2 within Input 1 before the value specified by Input 3.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 3
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

CountOccurencesAfter

Description:

The CountOccurencesAfter operation creates a Result by calculating the number of occurences of Input 2 within Input 1 after the value specified by Input 3.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 3
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

CountOccurencesOfWord

Description:

The CountOccurencesOfWord operation creates a Result by counting the number of occurences of Input 2 within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

CountOccurencesAfterIndex

Description:

The CountOccurencesAfterIndex operation creates a Result by calculating the number of occurences of Input 2 within Input 1 after the index (0-based) specified by Input 3.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 3
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int16
  • Int32
  • Int64
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

CountOccurencesAfterIndex

CountOccurencesBeforeIndex

Description:

The CountOccurencesBeforeIndex operation creates a Result by calculating the number of occurences of Input 2 within Input 1 before the index (0-based) specified by Input 3.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 3
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int16
  • Int32
  • Int64
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

Surround

Description:

The Surround operation creates a Result by surrounding all occurrences of Input 2 with Input 3 within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 3
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

WordCount

Description:

The WordCount operation creates a Result by determining the number of words within Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

WordCount

StringLengthDistance

Description:

The StringLengthDistance operation creates a Result by computing the distance between the lengths of Input 1 and Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

StringLengthDistance

DistanceMatrixLength

Description:

The DistanceMatrixLength operation creates a Result by evaluating Input 1 and Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

ReplaceDistance

Description:

The ReplaceDistance operation creates a Result by evaluating Input 1 and Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Double

LevenshteinDistance

Description:

The LevenshteinDistance operation creates a Result by evaluating Input 1 and Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

LevenshteinDistanceNorm

Description:

The LevenshteinDistanceNorm operation creates a Result by evaluating Input 1 and Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Double