Contact Us 1-800-596-4880

String Operations

The String Operations Action Step enables you to modify strings by using a variety of operations, including find and replace and trimming.

Properties

  • Input Text

    The string that you want to modify.

    Specify this value manually or use the wizard to define this value via the pin variable.

  • Use a regular expresion for string to find

    Select this option to evaluate the value specified in the Find what field in the wizard (StringToFind variable) as a regular expression and apply the regex to the Input Text.

    This option is valid only when using the string operation Find and replace text.

Inbound Variables

  • Input Text

    The string that you want to modify.

    Specify this value manually or by using the wizard to select a pin variable for the value.

  • StringToFind

    The string to search for inside the Input Text string.

  • StringToReplaceWith

    The string to replace the found instances of StringToFind.

  • CharacterToTrimAt

    The character to use as delimiter when using trim operations.

  • NumberOfCharacters

    The number of characters to count when using trim operations.

Outbound Variables

  • Result

    The modified string is output as the result. You can then use this string in subsequent Action Steps.

  • Result Length

    The length of the modified result string.

Wizard

75%

  • String operation

    The string operation you want to perform. The following operations are available:

    • Analyse

      Outputs the length of the specified input text string.

    • Find and replace text

      Searches and replaces text found in the input text. For example:

      • Input text (string) = MyTESTString

      • Find what = TEST

      • Replace with = NEW

      • Output = MyNEWString

    • Left (take first characters)

      Outputs the specified number of characters from the string, starting from the first character. For example:

      • Input text (string) = MyTESTString

      • Number of characters = 4

      • Output = MyTE

    • Right (take last characters)

      Outputs the specified number of characters from the string, starting from the last character. For example:

      • Input text (string) = MyTESTString

      • Number of characters = 4

      • Output = ring

    • Trim left (remove first characters)

      Removes the specified number of characters from the string, starting from the first character. For example:

      • Input text (string) = MyTESTString

      • Number of characters = 3

      • Output = ESTString

    • Trim right (remove last characters)

      Removes the specified number of characters from the string, starting from the last character. For example:

      • Input text (string) = MyTESTString

      • Number of characters = 3

      • Output = MyTESTStr

    • Takes first characters of the string until a specific character (specific character is not part of output)

      Outputs all characters between the beginning of the string and the first occurrence of the Character to trim at value. For example:

      • Input text (string) = MyTESTString

      • Character to trim at = t

      • Output = MyTESTS

        Note that the output string does not include the search character.

    • Takes last characters of the string until a specific character (specific character is not part of output)

      Outputs all characters between the last occurrence of the Character to trim at value and the end of the string. For example:

      • Input text (string) = MyTESTString

      • Character to trim at = T

      • Output = String

        Note that the output string does not include the search character.

    • Removes first characters of the string until a specific character (specific character is not part of output)

      Removes all characters between the beginning of the string and the first occurrence of the Character to trim at value. For example:

      • Input text (string) = MyTESTString

      • Character to trim at = T

      • Output = ESTString

        Note that the search character is removed from the output string.

    • Removes last characters of the string until a specific character (specific character is not part of output)

      Removes all characters between the last occurrence of the Character to trim at value and the end of the string. For example:

      • Input text (string) = MyTESTString

      • Character to trim at = T

      • Output = MyTES

        Note that the search character is removed from the output string.